DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=r4r9J5Uhl1/jyYCKo8JUmOj5kHaOIL/QCXdvNoWhZ7tMPyRB5voWLBBo6qRRG0j6w8d4UwnnpG1IfvDDlaSceJZx9h9zPc6TX9MUKRH/kJUj938lmtdKfPI3WkEhEMpbwB92ZD/B292Cc3hTZ3zy7jFJJc8A3Q3UdLGQFU4AzMs=
Message-ID: <dcc563d10804111041r42de8f4ftc64ac13ec709d273@mail.gmail.com>
Date: Fri, 11 Apr 2008 11:41:41 -0600
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Nacef LABIDI" <nacef.l@gmail.com>
Subject: Re: Get the last inserted id
Cc: pgsql-sql@postgresql.org
In-Reply-To: <f16f7ea00804111023xc2072ddk796b1e0336c14aac@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <f16f7ea00804111023xc2072ddk796b1e0336c14aac@mail.gmail.com>

On Fri, Apr 11, 2008 at 11:23 AM, Nacef LABIDI <nacef.l@gmail.com> wrote:
> Hi all,
>
> I was wondering if postgres can return the last ID inserted for a table
> which the primary key is autoincremented. I need to retrieve this ID in my
> code to continue processing on that inserted row.

smarlowe=# create table test (a serial primary key, b text);
NOTICE:  CREATE TABLE will create implicit sequence "test_a_seq" for
serial column "test.a"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
"test_pkey" for table "test"
CREATE TABLE
smarlowe=# insert into test (a,b) values (DEFAULT,'test') returning a;
 a
---
 1
(1 row)

INSERT 0 1

Note that there are other ways of doing it, but I really like the
returning clause.