Received: from home.priority.net (home.priority.net [204.27.108.182]) by hub.org (8.9.3/8.9.3) with ESMTP id RAA26492 for ; Wed, 2 Jun 1999 17:30:27 -0400 (EDT) (envelope-from tpham@mail.priority.net) Received: by home.priority.net with Internet Mail Service (5.5.2232.9) id ; Wed, 2 Jun 1999 16:46:29 -0500 Message-ID: <551413BBBB03D111BF880060B01AACCE0B38FA@home.priority.net> From: "Pham, Thinh" To: "'pgsql-sql@postgresql.org'" Subject: Getting primary key from insert statement Date: Wed, 2 Jun 1999 16:46:28 -0500 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2232.9) Content-Type: text/plain; charset="iso-8859-1" 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