Re: Return key from query

[Szymon Guz <mabewlun@xxxxxxxxx>]

On 2 November 2010 21:43, Jonathan Tripathy <jonnyt@xxxxxxxxxxx> wrote:

Hi everyone,

When adding a new record, we run an insert query which auto-increments the primary key for the table. However the method (in java) which calls this query must return the newly created key.

Any ideas on how to do this, preferably using a single transaction?

Thanks

Try insert returning, something like this:

INSERT INTO distributors (did, dname) VALUES (DEFAULT, 'XYZ Widgets')

ÂÂ RETURNING did;

http://www.postgresql.org/docs/9.0/static/sql-insert.html

regards

Szymon