The OID exists in every row, but you need to explicitly tell SELECT to
show it:
SELECT oid, * from foo;
shows every column in table foo, as well as the OID.
Ciao
--Louis <louis@bertrandtech.on.ca>
OpenBSD: Secure by default. http://www.openbsd.org/
On Fri, 2 Mar 2001, Luke Tudor - RSG wrote:
> Dear Postgres supporters,
>
> Given my earlier problem with backups; i.e. the error with an oid. Is it
> possible to
> determine what row relates to a specific oid? A way of listing objects
> with their oid number
> may provide me with a clue on what part of the database is causing a
> problem.
> Oh and thanks GH for your earlier explination on oid's.
>
> Best Regards,
> Luke.
> "Nothing Changes and Nothing stays the same, and life is still a simple
> game" ~ Justin Hayward
>