Postgres Pro
Downloads
Home   >   mailing lists

get the previous assigned sequence value - Mailing list pgsql-general

From Kevin Heflin
Subject get the previous assigned sequence value
Date
Msg-id Pine.LNX.4.10.9912081639280.11761-100000@mercury.shreve.net
Whole thread Raw
List pgsql-general
Tree view 
I've been looking through the online docs, so far have not found this
information.

After an INSERT, I want to retrieve the value of the sequence I use for
unique_ids

Any suggestions ?



Kevin

--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Production         | 333 Texas St #175    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: Re: [GENERAL] Suggested "minor" change to psql
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] How to stop implicit rollback on certain errors?