Postgres Pro
Downloads
Home   >   mailing lists

Re: Obtaining the primary key of the record just inserted - Mailing list pgsql-novice

From Sean Davis
Subject Re: Obtaining the primary key of the record just inserted
Date
Msg-id 47334F0C.4090508@mail.nih.gov
Whole thread Raw
In response to Obtaining the primary key of the record just inserted  ("Oliveiros Cristina" <oliveiros.cristina@marktest.pt>)
List pgsql-novice
Tree view 
Oliveiros Cristina 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() ; ?
>
> Any help deeply appreciated
Is the primary key a SERIAL column?

Sean

pgsql-novice by date:

Previous
From: "Oliveiros Cristina"
Date:
Subject: Obtaining the primary key of the record just inserted
Next
From: Hans-Peter Oeri
Date:
Subject: Re: Obtaining the primary key of the record just inserted