LAST_INSERT_ID equivalent - Mailing list 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


pgsql-general by date:

Previous
From: Steve Crawford
Date:
Subject: pg_conf idea (was Re: Postgres performance comments from a MySQL user)
Next
From: Steve Crawford
Date:
Subject: Re: need a method to ping a running database