Re: getting primary key values for inserted records? - Mailing list pgsql-jdbc

From Guido Fiala
Subject Re: getting primary key values for inserted records?
Date
Msg-id 200401281446.26641.guido.fiala@dka-gmbh.de
Whole thread Raw
In response to Re: getting primary key values for inserted records?  (Jeremy Buchmann <jeremy@wellsgaming.com>)
List pgsql-jdbc
Am Dienstag, 27. Januar 2004 22:26 schrieben Sie:
> > If you don't mind running two statements, you can select the next value
> > from the sequence and then put it in your insert statement.  Like this:
> >
> > $pkey = "SELECT nextval('sequence_name')";
> > "INSERT INTO table (id, ...) VALUES ($pkey, ...)";
> >

Yup! That is just fine, many thanks!

pgsql-jdbc by date:

Previous
From: Dave Cramer
Date:
Subject: Re: a little disillusioned
Next
From: Guido Fiala
Date:
Subject: setQueryTimeOut(1) - not expected result...