Re: Fw: postgresql experts please help - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Fw: postgresql experts please help
Date
Msg-id Pine.BSO.4.64.0710181601580.12647@leary.csoft.net
Whole thread Raw
In response to Re: Fw: postgresql experts please help  (Josh Berkus <josh@agliodbs.com>)
Responses Re: Fw: postgresql experts please help
List 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

pgsql-jdbc by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Fw: postgresql experts please help
Next
From: Josh Berkus
Date:
Subject: Re: Fw: postgresql experts please help