Postgres Pro
Downloads
Home   >   mailing lists

Getting back the primary key after INSERT - Mailing list pgsql-novice

From Scott W. Hill
Subject Getting back the primary key after INSERT
Date
Msg-id 06F9B658-C72D-11D5-9984-003065BDABEC@verisign.com
Whole thread Raw
Responses Re: Getting back the primary key after INSERT
Re: Getting back the primary key after INSERT
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: "Josh Berkus"
Date:
Subject: Re: [PHP] Can't postgres join tables on varchar fields ?
Next
From: "Josh Berkus"
Date:
Subject: Re: Getting back the primary key after INSERT