| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Mihail Nasedkin <m(dot)nasedkin(dot)perm(at)mail(dot)ru> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: OID's |
| Date: | 2005-01-20 16:48:30 |
| Message-ID: | 20050120164830.GB41081@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron Mayer | 2005-01-20 16:49:39 | Re: [SQL] OFFSET impact on Performance??? |
| Previous Message | KÖPFERL Robert | 2005-01-20 16:39:39 | automatic table locking on too many locked records? |