Re: [GENERAL] Using autogenerated primary key in transaction

2010-01-04 Thread A. Kretschmer
In response to Andrus : > INSERT generates SERIAL primary key column value automatically. > > How to save this value for use in same transaction ? > How to get autogenerated primary key for >=8.0 servers ? There are some functions to get that value: test=# create table andrus(id serial primary

Re: [GENERAL] Using autogenerated primary key in transaction

2010-01-04 Thread John R Pierce
Andrus wrote: How to get autogenerated primary key for >=8.0 servers ? currval('sequencename') -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general