Re: postgres metadata - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: postgres metadata
Date
Msg-id 20031126174134.GB15041@dcc.uchile.cl
Whole thread Raw
In response to postgres metadata  (Barbara Lindsey <blindsey@cog.ufl.edu>)
List pgsql-general
On Wed, Nov 26, 2003 at 11:20:54AM -0500, Barbara Lindsey wrote:
> Is there something in Postgres that corresponds to the rowid
> pseudocolumn in Oracle, which represents the unique address of the row
> of data in the table?  If so, how would you access that in a query?

Maybe ctid?  It's the physical column position, so it changes as soon as
the row is UPDATEd, or even during VACUUM.

--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"La espina, desde que nace, ya pincha" (Proverbio africano)

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: cross table indexes?
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL is much faster than MySQL, only when...