Thread: Do the datatypes have set id/oid that are constant?

Do the datatypes have set id/oid that are constant?

From
Mark Worsdall
Date:
Hi,

When I do a \dT I get a list of the postgres datatypes, is there a SQL 
version of \dT and can one get the oid's for this list?

M.
-- 
Mark Worsdall
https://www.paypal.com/refer/pal=LS79YHQ9VUGLJ


Re: Do the datatypes have set id/oid that are constant?

From
Bruce Momjian
Date:
Mark Worsdall wrote:
> Hi,
> 
> When I do a \dT I get a list of the postgres datatypes, is there a SQL 
> version of \dT and can one get the oid's for this list?

Use 'psql -E' to see the \dT query, and add the oid.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073