Postgres Pro
Downloads
Home   >   mailing lists

Re: Do the datatypes have set id/oid that are constant? - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Do the datatypes have set id/oid that are constant?
Date
Msg-id 200209161702.g8GH28u20232@candle.pha.pa.us
Whole thread Raw
In response to Do the datatypes have set id/oid that are constant?  (Mark Worsdall <mysql@wizdom.org.uk>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Ngan Duong
Date:
Subject: please delete my email address from your list
Next
From: Bruce Momjian
Date:
Subject: Re: Table alias in DELETE statements