Re: Last_Inserted Value

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andre Schubert <andre(dot)schubert(at)km3(dot)de>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Last_Inserted Value
Date: 2002-03-28 14:40:35
Message-ID: 25557.1017326435@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Andre Schubert <andre(dot)schubert(at)km3(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gaetano Mendola 2002-03-28 18:54:15 Log rotation
Previous Message Radoslaw Stachowiak 2002-03-28 14:34:19 7.2 timetz/time/current_time improper behaviour report