From: | Louis Bertrand <louis(at)bertrandtech(dot)on(dot)ca> |
---|---|
To: | Luke Tudor - RSG <ltt(at)pml(dot)ac(dot)uk> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Finding out what relates to an oid. |
Date: | 2001-03-02 13:20:58 |
Message-ID: | Pine.BSO.4.20.0103020819060.27200-100000@grendel.bts |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)bertrandtech(dot)on(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Catalin CIOCOIU | 2001-03-02 15:50:53 | Last ID |
Previous Message | Luke Tudor - RSG | 2001-03-02 12:32:16 | Finding out what relates to an oid. |