Re: postgres metadata

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Barbara Lindsey <blindsey(at)cog(dot)ufl(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: postgres metadata
Date: 2003-11-26 17:41:35
Message-ID: 20031126174134.GB15041@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lynn.Tilby 2003-11-26 17:59:27 Re: Embedded Vacuum Still Not Working...
Previous Message Richard Huxton 2003-11-26 17:18:33 Re: cross table indexes?