Getting OID after Insert

From: Bruce Cota <bruce(at)vivi(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Getting OID after Insert
Date: 2001-10-18 03:18:44
Message-ID: 3BCE4A13.F815847@vivi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Crouch 2001-10-18 03:36:00 Large Files?
Previous Message rdack 2001-10-18 00:13:01 can't create a database