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@postgresql.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@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749