PostgreSQL OID Column on INSERT

Frank D. Engel, Jr. fde101 at
Tue Sep 28 15:38:45 EDT 2004

A while back I stumbled on a prior thread with this same question, but 
I never did see a resolution to the root question.

When PostgreSQL performs an INSERT, it returns a unique OID number for 
the inserted row.  Is there any way to retrieve the OID value returned 
by the INSERT statement from RevDB?

In my case, the other values, even in combination, are not guaranteed 
unique -- except one, which is autogenerated by the database (a SERIAL 
number), so there is no other way for me to be certain of grabbing the 
exact record I just inserted, something I need to be able to do.

Thank you!

Frank D. Engel, Jr.  <fde101 at>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten 
Son, that whosoever believeth in him should not perish, but have 
everlasting life.

$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at

More information about the use-livecode mailing list