Re: Finding out what relates to an oid.

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
>