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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly -- Martijn van Oosterhout <[EMAIL PROTECTED]> 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
pgp00000.pgp
Description: PGP signature
