Re: postgres metadata - Mailing list pgsql-general

From James Thompson
Subject Re: postgres metadata
Date
Msg-id Pine.LNX.4.44.0311261039070.13155-100000@newton.math.ksu.edu
Whole thread Raw
In response to postgres metadata  (Barbara Lindsey <blindsey@cog.ufl.edu>)
Responses Re: postgres metadata
Re: postgres metadata
List 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
->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<



pgsql-general by date:

Previous
From: Barbara Lindsey
Date:
Subject: postgres metadata
Next
From: Hervé Piedvache
Date:
Subject: pg_dump table schema ...