Getting back the primary key after INSERT

Поиск
Список
Период
Сортировка
Искать
От
Scott W. Hill
Тема
Getting back the primary key after INSERT
Дата
Msg-id
06F9B658-C72D-11D5-9984-003065BDABEC@verisign.com
Список
Дерево обсуждения
Getting back the primary key after INSERT "Scott W. Hill" <shill@verisign.com>
Re: Getting back the primary key after INSERT hodges@xprt.net
Re: Getting back the primary key after INSERT "Josh Berkus" <josh@agliodbs.com>
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 по дате отправления
От: Josh Berkus
Дата:
От: hodges@xprt.net
Дата:
FAQ