Re: get the inserted row id

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: "Zouari Fourat" <fourat(at)gmail(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: get the inserted row id
Date: 2006-02-20 09:55:22
Message-ID: 21DF930A-15C8-4B73-B00F-3AC35C6818F6@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice


On Feb 20, 2006, at 18:42 , Zouari Fourat wrote:

> Hello all,
> How can i get the last inserted row id (like in mysql : LAST INSERT
> ID)

http://www.postgresql.org/docs/8.1/interactive/functions-sequence.html
http://www.postgresql.org/docs/faqs.FAQ.html#item4.11.2

You may find the other FAQ items and the documentation of the
documentation useful as well.

Michael Glaesemann
grzm myrealbox com

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2006-02-20 10:02:38 Re: get the inserted row id
Previous Message Zouari Fourat 2006-02-20 09:42:06 get the inserted row id