Postgres Pro
Downloads
Home   >   mailing lists

Is there a reason why no table OID in pg_tables - Mailing list pgsql-hackers

From Richard Huxton
Subject Is there a reason why no table OID in pg_tables
Date
Msg-id 200310181607.08167.dev@archonet.com
Whole thread Raw
Responses Re: Is there a reason why no table OID in pg_tables  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
I was just trying to compare constraints in two versions of a database and the 
obvious (to me) join from pg_constraint to pg_tables wasn't possible.

Not a real problem, I just used pg_class, but is the lack of oid in pg_tables 
a design decision and if so why?

--  Richard Huxton Archonet Ltd

pgsql-hackers by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: Mapping Oracle types to PostgreSQL types
Next
From: Tom Lane
Date:
Subject: Re: Is there a reason why no table OID in pg_tables