Re: OID's - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: OID's
Date
Msg-id 20050120164830.GB41081@winnie.fuhr.org
Whole thread Raw
In response to OID's  (Mihail Nasedkin <m.nasedkin.perm@mail.ru>)
Responses Re: OID's
List pgsql-sql
On Thu, Jan 20, 2005 at 03:45:58PM +0500, Mihail Nasedkin wrote:

> How (where) I can get all OID's of the PostgeSQL
> installation?
> In other words where OID's is stored? Is it stored in special table?

See the "System Columns" section in the "Data Definition" chapter
of the PostgreSQL documentation.  Tables that store objects with
OIDs should have an oid column; you could query pg_attribute to
find out what tables those are.

> I would like use some SQL queries with the all OID's.

To what end?  Are you aware that PostgreSQL allows tables to be
created without OIDs?  What problem are you trying to solve?

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-sql by date:

Previous
From: KÖPFERL Robert
Date:
Subject: automatic table locking on too many locked records?
Next
From: Richard Huxton
Date:
Subject: Re: [PERFORM] OFFSET impact on Performance???