Re: Using autogenerated primary key in transaction

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 key);
NOTICE: CREATE TABLE will create implicit sequence "andrus_id_seq" for serial column "andrus.id"
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "andrus_pkey" for table "andrus"
CREATE TABLE
test=*# insert into andrus values (default);
INSERT 0 1
test=*# select currval(pg_get_serial_sequence('andrus','id'));
currval
---------
1
(1 row)

HTH, Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
GnuPG: 0x31720C99, 1006 CCB4 A326 1D42 6431 2EB0 389D 1DC2 3172 0C99