Home > mailing lists

Re: Last_Inserted Value - Mailing list pgsql-admin

From	Tom Lane
Subject	Re: Last_Inserted Value
Date	March 28, 2002 12:41:21
Msg-id	25557.1017326435@sss.pgh.pa.us Whole thread Raw
In response to	Last_Inserted Value (Andre Schubert <andre.schubert@km3.de>)
List	pgsql-admin

Tree view

Andre Schubert <andre.schubert@km3.de> writes:
> All three tables use the same sequence to increment their id.
> I want to know if it is possible to find the id of the inserted value of
> foo.

Try "currval".

            regards, tom lane

pgsql-admin by date:

From: Radoslaw Stachowiak
Date: 28 March 2002, 12:35:26
Subject: 7.2 timetz/time/current_time improper behaviour report

From: "Gaetano Mendola"
Date: 28 March 2002, 16:54:45
Subject: Log rotation

Re: Last_Inserted Value - Mailing list pgsql-admin

Previous

Next