Hi Jinqiang,
Try: SELECT oid FROM pg_type WHERE typname='text';
You can always make that into a function.
Chris
> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of Jinqiang Han
> Sent: Tuesday, 24 December 2002 10:00 AM
> To: pgsql-hackers@postgresql.org
> Subject: [HACKERS] about data type id
>
>
> hello,
> Is there a function that I can get type id from type name, such
> as from 'text' to 25, 'int' to 23.
> thanks in advance.
> Jinqiang Han
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>