Postgres Pro
Downloads
Home   >   mailing lists

Re: How do I get an OID from a record in table? - Mailing list pgsql-novice

From Jaime Casanova
Subject Re: How do I get an OID from a record in table?
Date
Msg-id c2d9e70e0511261612j56bbf205o676cf97dfd1ab25@mail.gmail.com
Whole thread Raw
In response to FW: How do I get an OID from a record in table?  ("Scott Simpson" <Scott.Simpson@computer.org>)
Responses Re: How do I get an OID from a record in table?  (Norberto Meijome <sys@meijome.net>)
List pgsql-novice
Tree view 
On 11/26/05, Scott Simpson <Scott.Simpson@computer.org> wrote:
> If I create a table with an OID field type, how do I set that field type?
> That is, I have to look up the OID value in another table somewhere to set
> my OID field and I don't know how to do that. (I'm trying to get one field
> to point to another record). ADVthanksANCE.
>

SELECT oid FROM your_referenced_table;

oid is an especial field that is present in all row unless you had
specified WITHOUT OIDS...

i think in 8.1 WITHOUT OIDS is the DEFAULT...

it's not a good idea to do what you want to do... use a serial instead

--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)

pgsql-novice by date:

Previous
From: john hedge
Date:
Subject: Linux Format Gambas Easy Database Access!
Next
From: Marcus Engene
Date:
Subject: Re: Linux Format Gambas Easy Database Access!