Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Is there a reason why no table OID in pg_tables
Date
Msg-id 1454.1066491169@sss.pgh.pa.us
Whole thread Raw
In response to Is there a reason why no table OID in pg_tables  (Richard Huxton <dev@archonet.com>)
Responses Re: Is there a reason why no table OID in pg_tables
List pgsql-hackers
Tree view 
Richard Huxton <dev@archonet.com> writes:
> 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?

Views don't have OIDs (or any other system columns).  We could export
pg_class.oid as an ordinary column in pg_tables, but then it would be
in your face whether you wanted it or not.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Richard Huxton
Date:
Subject: Is there a reason why no table OID in pg_tables
Next
From: Richard Huxton
Date:
Subject: Re: Is there a reason why no table OID in pg_tables