Postgres Pro
Downloads
Home   >   mailing lists

Thread: Obtaining the primary key of the record just inserted

Obtaining the primary key of the record just inserted

From
"Oliveiros Cristina"
Date:
 
Hello, All,
 
I have the need to know the primary key assigned to a record I've just INSERTed .
 
Is there an easy way to solve this ?
 
Similar to SQLServer's  SELECT scope_identity() ; ?
 
Any help deeply appreciated
 
Best,
Oliveiros

Re: Obtaining the primary key of the record just inserted

From
"Scott Marlowe"
Date:
On Nov 8, 2007 11:56 AM, Oliveiros Cristina
<oliveiros.cristina@marktest.pt> wrote:
>
> Hello, All,
>
> I have the need to know the primary key assigned to a record I've just
> INSERTed .
>
> Is there an easy way to solve this ?
>
> Similar to SQLServer's  SELECT scope_identity() ; ?

In 8.2 and up:

insert into table a (info) values ('abc') returning id;

Re: Obtaining the primary key of the record just inserted

From
"Oliveiros Cristina"
Date:
It worked perfectly.
Thanks a million, Scott.

Best,
Oliveiros
----- Original Message ----- 
From: "Scott Marlowe" <scott.marlowe@gmail.com>
To: "Oliveiros Cristina" <oliveiros.cristina@marktest.pt>
Cc: <pgsql-sql@postgresql.org>
Sent: Thursday, November 08, 2007 6:03 PM
Subject: Re: [SQL] Obtaining the primary key of the record just inserted


> On Nov 8, 2007 11:56 AM, Oliveiros Cristina
> <oliveiros.cristina@marktest.pt> wrote:
>>
>> Hello, All,
>>
>> I have the need to know the primary key assigned to a record I've just
>> INSERTed .
>>
>> Is there an easy way to solve this ?
>>
>> Similar to SQLServer's  SELECT scope_identity() ; ?
> 
> In 8.2 and up:
> 
> insert into table a (info) values ('abc') returning id;
>