Re: Getting back the primary key after INSERT

Scott,
I am pretty new at this also but here is what I used.
After adding a record to table persons I need to get the latest
value from its sequence file, persons_id_seq, and use it to
link a new record in table addresses.

/* Get the ID value for the volunteer just added to persons table
We will use this as the index for the addresses table */
$personidsql = "select last_value from persons_id_seq";
$result = pg_Exec($GLOBALS["localhost"], $personidsql);
$myrow = pg_fetch_row ($result,0); echo "person id",$myrow[0],"<BR>";

Now key value is in $myrow[0].

/* Add Mailing Address */
if ($maddress1 != "") {
$address_type = "mailing";
$sqladdress = "insert into addresses
(person_id,address_type, address1, address2, city, state_code,
province,
country_code, postalcode, remarks)
values
('$myrow[0]','$address_type','$maddress1','$maddress2','$mcity',
'$mstate_code','$mprovince','$mcountry_code',
'$mpostalcode','$remarks')";

Cheers, Tom

On 22 Oct 2001, at 13:40, Scott W. Hill wrote:

> I'm pretty new with JDBC and Postgres. Here's my question:
>
> I have a table with an automatically incrementing key. I'm inserting
> things into the table via an INSERT statement from JDBC. Once I do the
> INSERT, I want to know what new number was assigned by the database to
> the row that I just inserted. Any ideas?
>
> --Scott
Tom Hodges, hodges(at)xprt(dot)net or tom_hodges(at)yahoo(dot)com
ICQ 10149621, YahooMessenger tom_hodges
Mail: 14314 SW Allen Blvd, #317; Beaverton OR 97005 USA