Postgres Pro
Downloads
Home   >   mailing lists

Getting OID after Insert - Mailing list pgsql-general

From Bruce Cota
Subject Getting OID after Insert
Date
Msg-id 3BCE4A13.F815847@vivi.com
Whole thread Raw
Responses Re: Getting OID after Insert  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Getting OID after Insert  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view 
Is there a way, in SQL, to access the oid of the row created
by an immediately preceding insert statement?

e.g.

insert into t (x, y) values (1, 2);

select * from t where oid = <what goes here?>

Thanks for any advice.

-Bruce


 Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
    ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
                http://www.usenet.com

pgsql-general by date:

Previous
From: Alan
Date:
Subject: newbie authentication/automated backup (pg_dumpall) questions
Next
From: huongch@bigfoot.com (Flancer)
Date:
Subject: Break both? (Was To Postgres Devs : Wouldn't changing the select limit )