Re: postgres metadata

From: James Thompson <jamest(at)math(dot)ksu(dot)edu>
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 16:39:43
Message-ID: Pine.LNX.4.44.0311261039070.13155-100000@newton.math.ksu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I think oid is what you want.

select oid,* from table;

Take Care,
James

On Wed, 26 Nov 2003, 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?
>
>
> --
> Barbara E. Lindsey,
> COG RDC
> Phone: (352) 392-5198 ext. 314 Fax: (352) 392-8162
>
> ----
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
James Thompson 138 Cardwell Hall Manhattan, Ks 66506 785-532-0561
Kansas State University Department of Mathematics
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hervé Piedvache 2003-11-26 16:55:54 pg_dump table schema ...
Previous Message Barbara Lindsey 2003-11-26 16:20:54 postgres metadata