Re: Finding out what relates to an oid. - Mailing list pgsql-novice

From Louis Bertrand
Subject Re: Finding out what relates to an oid.
Date
Msg-id Pine.BSO.4.20.0103020819060.27200-100000@grendel.bts
Whole thread Raw
In response to Finding out what relates to an oid.  (Luke Tudor - RSG <ltt@pml.ac.uk>)
List pgsql-novice
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
>


pgsql-novice by date:

Previous
From: Luke Tudor - RSG
Date:
Subject: Finding out what relates to an oid.
Next
From: Heath Johns
Date:
Subject: Permissions