get the inserted row id
This is a discussion on get the inserted row id within the pgsql Novice forums, part of the PostgreSQL category; --> Hello all, How can i get the last inserted row id (like in mysql : LAST INSERT ID) ---------------------------(end ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 09:36 PM
| ||||
| ||||
 get the inserted row id Hello all, How can i get the last inserted row id (like in mysql : LAST INSERT ID) ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org      |
|
04-17-2008, 09:36 PM
| |||
| |||
| Re: get the inserted row id 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/i...-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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |
|
04-17-2008, 09:36 PM
| ||||
| ||||
| Re: get the inserted row id am 20.02.2006, um 10:42:06 +0100 mailte Zouari Fourat folgendes: > Hello all, > How can i get the last inserted row id (like in mysql : LAST INSERT ID) With currval(). Read our docu: http://www.postgresql.org/docs/8.1/i...-sequence.html Andreas -- Andreas Kretschmer (Kontakt: siehe Header) Heynitz: 035242/47215, D1: 0160/7141639 GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net === Schollglas Unternehmensgruppe === ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
Linear Mode
