getting a sequence value - Mailing list pgsql-jdbc

From Nico
Subject getting a sequence value
Date
Msg-id d1mb4u$1j89$1@news.hub.org
Whole thread Raw
Responses Re: getting a sequence value
Re: getting a sequence value
List pgsql-jdbc
Hi,
I have two tables where the second table has a foreign key to the first one.
When I insert a row in the first one, I need the value of the ID generated
by a sequence in the first table to insert it in the foreign key column in
the second table. Except I don't know how to do this in Java/PostgreSQL...
Anyone knows how?
Table data:
Table 1:
Field1 (integer) default: nextval('public."tblTable1_FieldID_seq"'::text)
other field...
Table 2:
Field1 (integer) default: nextval('public."tblTable2_FieldID_seq"':text)
Field2 (integer) foreign key that references to Field1 in Table 1...

So when I do this:
INSERT INTO "tblTable1"(other fields...) VALUES(...);
how do I know what to put in here?
INSERT INTO "tblTable2"("Field2", other fields...) VALUES(???, ...);

I know in MS SQL server and Oracle one uses an old and new resultset to
resolve this issue, but haven't a clue how to do this in Java/PostgreSQL...

Nico.



pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: [Patch] JDBC3 Blob support
Next
From: Dave Cramer
Date:
Subject: Re: getting a sequence value