| From: | Josh Kupershmidt <schmiddy(at)gmail(dot)com> |
|---|---|
| To: | M(dot) Emre Çolak <memrecolak(at)hotmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: getting auto increment id value |
| Date: | 2011-12-20 14:38:27 |
| Message-ID: | CAK3UJREU8nK7zhWrHBgbsxWA54ztXo_c5XWbkewL3XLfvCGL1Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On Tue, Dec 13, 2011 at 3:52 AM, M. Emre Çolak <memrecolak(at)hotmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Northam | 2011-12-21 18:50:04 | TRIGGER FUNCTION - TO CREATE TABLE name AS SELECT |
| Previous Message | Jean-Yves F. Barbier | 2011-12-19 16:37:02 | Re: How to establish a SSL connection to a postgresql server |