Hi, is there a way you can get back the primary key (serialized) from an
insert you just do on a table. For example i have a table called "order" and
i want to get the pid of that record so i can use it in the "orderdetail"
table. It would be nice if that same insert statement could also return the
pid.
Table structure:
create table order (pid serial, orddate date);
create table orderdetail (pid serial, orderpid int, name varchar(50));
Insert statement:
insert into order (date) values ('6/2/1999')
order table
pid | orddate
----------------
1 | 6/2/1999
orderdetail table
pid | orderpid | name
--------------------------
1 | 1 | pencil
2 | 1 | pen
I know there must be a way, but i just couldn't find it in either the pgsql
docs or faq. Thanks in advance,
Thinh