Re: postgres metadata

Please remember:

- OIDs are NOT unique
- CTIDs are unique but not constant
- SERIALs are unique and forever

On Wed, Nov 26, 2003 at 10:39:43AM -0600, James Thompson wrote:
>
> 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
> ->->->->->->->->->->->->->->->->->->---<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<-<
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato