On Tue, Dec 13, 2011 at 3:52 AM, M. Emre Çolak <memrecolak@hotmail.com> 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