Re: Return key from query

On 2 November 2010 21:43, Jonathan Tripathy <jonnyt(at)abpni(dot)co(dot)uk> 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