Re: getting auto increment id value

Поиск
Список
Период
Сортировка
Искать
От
Josh Kupershmidt
Тема
Re: getting auto increment id value
Дата
Msg-id
CAK3UJREU8nK7zhWrHBgbsxWA54ztXo_c5XWbkewL3XLfvCGL1Q@mail.gmail.com
Ответ на
getting auto increment id value (M. Emre Çolak)
Список
Дерево обсуждения
type list "Jean-Yves F. Barbier" <12ukwn@gmail.com>
Re: type list Merlin Moncure <mmoncure@gmail.com>
Re: type list "Jean-Yves F. Barbier" <12ukwn@gmail.com>
Re: type list Merlin Moncure <mmoncure@gmail.com>
getting auto increment id value M. Emre Çolak <memrecolak@hotmail.com>
Re: getting auto increment id value Josh Kupershmidt <schmiddy@gmail.com> 
On Tue, Dec 13, 2011 at 3:52 AM, M. Emre Çolak  wrote:

>   I have a table and it's only distinct value is it's auto incremented id. I
> need to insert like 80.000 rows at ones so I have some time issues. Problem
> is I need a way to get a return value which is id of my inserted row since I
> need that id for another insert action. I think I should use a function for
> this but I am not sure how I can get Id of my inserted row.

Use INSERT INTO tbl ... RETURNING your_auto_inc_column. See also the
docs for the RETURNING clause at:
  http://www.postgresql.org/docs/current/static/sql-insert.html

Josh
В списке pgsql-novice по дате отправления
Предыдущее
От: Jean-Yves F. Barbier
Дата:
Следующее
От: Daniel Northam
Дата:
FAQ