Postgres Pro
Downloads
Home   >   mailing lists

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

From Oliveiros Cristina
Subject Obtaining the primary key of the record just inserted
Date
Msg-id 009901c82230$a799d3b0$ec5a3d0a@marktestcr.marktest.pt
Whole thread Raw
Responses Re: Obtaining the primary key of the record just inserted
List pgsql-sql
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-sql by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Partitioning and Foreign Keys
Next
From: "Scott Marlowe"
Date:
Subject: Re: Obtaining the primary key of the record just inserted