Re: postgres metadata

On Wed, 26 Nov 2003, Barbara Lindsey wrote:

> so what do you have to do to create the table with oids?
> I am using v7.4
It's still default in 7.4. (to create with OID's).

You can optionally create a table WITHOUT OIDs in 7.3+.

> 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
>
>
>
> Larry Rosenman wrote:
> > On Wed, 26 Nov 2003, James Thompson wrote:
> >
> >
> >>I think oid is what you want.
> >>
> >>select oid,* from table;
> >>
> >
> > Not if the table is created without OID's. Which may become default
> > in 7.5.
> >
>
>
>
>
>

--
Larry Rosenman http://www.lerctr.org/~ler
Phone: +1 972-414-9812 E-Mail: ler(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749