Re: get the inserted row id

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: get the inserted row id
Date: 2006-02-20 10:02:38
Message-ID: 20060220100238.GF9638@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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/interactive/functions-sequence.html

Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Oleg 2006-02-20 10:27:01 Re: [postgis-users] PostGIS Geometry column
Previous Message Michael Glaesemann 2006-02-20 09:55:22 Re: get the inserted row id