pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Do the datatypes have set id/oid that are constant?
2+ messages / 2 participants
[nested] [flat]

* Do the datatypes have set id/oid that are constant?
@ 2002-09-10 21:50  Mark Worsdall <mysql@wizdom.org.uk>
  0 siblings, 1 reply; 2+ messages in thread

From: Mark Worsdall @ 2002-09-10 21:50 UTC (permalink / raw)
  To: pgsql-sql

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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Do the datatypes have set id/oid that are constant?
@ 2002-09-16 17:02  Bruce Momjian <pgman@candle.pha.pa.us>
  parent: Mark Worsdall <mysql@wizdom.org.uk>
  0 siblings, 0 replies; 2+ messages in thread

From: Bruce Momjian @ 2002-09-16 17:02 UTC (permalink / raw)
  To: Mark Worsdall <mysql@wizdom.org.uk>; +Cc: pgsql-sql

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, Pennsylvania 19073



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2002-09-16 17:02 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-09-10 21:50 Do the datatypes have set id/oid that are constant? Mark Worsdall <mysql@wizdom.org.uk>
2002-09-16 17:02 ` Bruce Momjian <pgman@candle.pha.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox