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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
