From: Michael Fuhr <mike@fuhr.org>
To: Mihail Nasedkin <m.nasedkin.perm@mail.ru>
Cc: pgsql-sql@postgresql.org
Subject: Re: OID's
Date: Thu, 20 Jan 2005 09:48:30 -0700
Message-ID: <20050120164830.GB41081@winnie.fuhr.org> (raw)
In-Reply-To: <3628044953.20050120154558@mail.ru>
References: <3628044953.20050120154558@mail.ru>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, m.nasedkin.perm@mail.ru
Subject: Re: OID's
In-Reply-To: <20050120164830.GB41081@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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