Home > mailing lists

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

From	Hans-Peter Oeri
Subject	Re: Obtaining the primary key of the record just inserted
Date	November 8, 2007 18:27:40
Msg-id	47336281.1040906@oeri.ch Whole thread Raw
In response to	Obtaining the primary key of the record just inserted ("Oliveiros Cristina" <oliveiros.cristina@marktest.pt>)
List	pgsql-novice

Hi!

Oliveiros Cristina wrote:

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 ?

I prefer:
INSERT INTO [...] RETURNING id;

HPO

From: Sean Davis
Date: 08 November 2007, 17:02:00
Subject: Re: Obtaining the primary key of the record just inserted

From: "David Monarchi"
Date: 08 November 2007, 23:13:36
Subject: Constructing two-dimensional arrays from a query