On 2 November 2010 21:43, Jonathan Tripathy <jon...@abpni.co.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
