On 11/02/2010 01:43 PM, Jonathan Tripathy 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
>
Use "returning":
create table foo (bar serial, baz text);
insert into foo (baz) values ('test') returning bar;
bar
-----
1
(1 row)
Cheers,
Steve