Re: Finding out what relates to an oid.

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
>

In response to

Browse pgsql-novice by date

  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.