Postgres Pro
Downloads
Home   >   mailing lists

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

From Oliveiros Cristina
Subject Obtaining the primary key of the record just inserted
Date
Msg-id 007d01c8222f$d25a26f0$ec5a3d0a@marktestcr.marktest.pt
Whole thread Raw
Responses Re: Obtaining the primary key of the record just inserted  (Sean Davis <sdavis2@mail.nih.gov>)
Re: Obtaining the primary key of the record just inserted  (Hans-Peter Oeri <hp@oeri.ch>)
List pgsql-novice
Tree view
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

pgsql-novice by date:

Previous
From: "Nico Callewaert"
Date:
Subject: Re: Trigger function syntax
Next
From: Sean Davis
Date:
Subject: Re: Obtaining the primary key of the record just inserted