Postgres Pro
Downloads
Home   >   mailing lists

getting auto increment id value - Mailing list pgsql-novice

From M. Emre Çolak
Subject getting auto increment id value
Date
Msg-id DUB110-DS244924AB9860CA93A20F14D7BD0@phx.gbl
Whole thread Raw
In response to type list  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
Responses Re: getting auto increment id value
List pgsql-novice
Tree view 
Hi,
    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.
Thanks.
M. Emre Çolak

pgsql-novice by date:

Previous
From: Pandu Poluan
Date:
Subject: Re: SELECT from two tables with different field names?
Next
From: Aleksej Trofimov
Date:
Subject: Postgresql array parser