Re: Fw: postgresql experts please help

From: Kris Jurka <books(at)ejurka(dot)com>
To: Josh Berkus <josh(at)agliodbs(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org, Andrei Ilitchev <andrei(dot)ilitchev(at)oracle(dot)com>, Marina Vatkina <Marina(dot)Vatkina(at)sun(dot)com>
Subject: Re: Fw: postgresql experts please help
Date: 2007-10-18 20:05:42
Message-ID: Pine.BSO.4.64.0710181601580.12647@leary.csoft.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

On Thu, 18 Oct 2007, Josh Berkus wrote:

> I'm pretty sure there's a version of lastval() which takes the table
> name as a parameter. That would be the safer one to use.
>

There is:

SELECT currval(pg_get_serial_sequence('mytab','mycol'));

Kris Jurka

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Josh Berkus 2007-10-18 20:14:24 Re: Fw: postgresql experts please help
Previous Message Josh Berkus 2007-10-18 19:57:37 Re: Fw: postgresql experts please help