Re: What is the postgres sql command for last_user_id ??? - Mailing list pgsql-performance

From Michael Fuhr
Subject Re: What is the postgres sql command for last_user_id ???
Date
Msg-id 20050302081257.GB47871@winnie.fuhr.org
Whole thread Raw
In response to What is the postgres sql command for last_user_id ???  (amrit@health2.moph.go.th)
List pgsql-performance
On Tue, Mar 01, 2005 at 10:46:02PM +0700, amrit@health2.moph.go.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/

pgsql-performance by date:

Previous
From: "Ken Egervari"
Date:
Subject: Help with tuning this query
Next
From: Richard Huxton
Date:
Subject: Re: Help with tuning this query