Re: What is the postgres sql command for last_user_id ???

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: amrit(at)health2(dot)moph(dot)go(dot)th
Cc: PGsql-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: What is the postgres sql command for last_user_id ???
Date: 2005-03-02 08:12:57
Message-ID: 20050302081257.GB47871@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tue, Mar 01, 2005 at 10:46:02PM +0700, amrit(at)health2(dot)moph(dot)go(dot)th wrote:

> I would like to know whether there is any command which the server will give the
> record ID back to the client when client puts the data and the server generates
> an autoincrement ID for that record.

See "How do I get the value of a SERIAL insert?" and the question
immediately following it in the FAQ:

http://www.postgresql.org/files/documentation/faqs/FAQ.html#4.11.2

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Richard Huxton 2005-03-02 08:58:06 Re: Help with tuning this query
Previous Message Ken Egervari 2005-03-02 06:51:11 Help with tuning this query