LAST_INSERT_ID equivalent

Erik Price <eprice@ptc.com>

From: Erik Price <eprice@ptc.com>
To: pgsql-general@postgresql.org
Date: 2003-06-12T17:14:59Z
Lists: pgsql-general
I have a table with a SEQUENCE on it that increments the primary key (a 
BIGINT column) of the table whenever a new insert is performed.

Is there a way to determine the last incremented value, so that if I do 
an insert, I can record the primary key of the record somewhere?  I'm 
interested in any technique for doing this, but especially a 
JDBC-specific solution.

Sorry if the answer should be obvious but I am coming from MySQL and 
trying to learn the ANSI equivalent of the MySQL features.



Thanks,


Erik