Re: about data type id

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(at)postgresql(dot)org
> [mailto:pgsql-hackers-owner(at)postgresql(dot)org]On Behalf Of Jinqiang Han
> Sent: Tuesday, 24 December 2002 10:00 AM
> To: pgsql-hackers(at)postgresql(dot)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
>