postgresql fields and sequences

[gerardg]

I think I saw in the docs that fields could be set up to automatically use a sequence (rather than using nextval manually), but can't find in the docs how to do this.

[smarlowe]

Just do this:

create table yada (field1 text, int1 int, id serial);

and postgresql will create a sequence for the id field and make the yada table reference it.

Then, just insert like so:

insert into yada (field1, int1) values ('hubert',22);

and postgresql will autoinsert the nextval of the sequence for you.

[[deleted]]

Small note:
In MySQL you can use the mysql_insert_id() to get the last inserted auto_increment value.

This does not exist for postgreSQL (because you can have more than one serial in each column)

You'll have to use pg_lastoid() to get the last OID that was used by PG, use that to identify the newly created record, and SELECT the serial column from that.

Bit of a workaround, but with lovely stored procedures you can automate most of it.