Re: getting back autonumber just inserted - Mailing list pgsql-sql

From Edmund Bacon
Subject Re: getting back autonumber just inserted
Date
Msg-id 4202AB60.90608@onesystem.com
Whole thread Raw
In response to Re: getting back autonumber just inserted  (Sean Davis <sdavis2@mail.nih.gov>)
List pgsql-sql
Perhaps you meant:
http://www.postgresql.org/docs/8.0/interactive/functions-info.html#FUNCTIONS-INFO-SCHEMA-TABLE

in particular  |pg_get_serial_sequence|(table_name, column_name)



Sean Davis wrote:

>
> On Feb 3, 2005, at 5:16 PM, lorid wrote:
>
>> I could have sworn I kept a copy of prior emails that discussed how 
>> to  get back a value that was just inserted into a autonumber (or in  
>> postgresql case a sequence number)
>>
>
> See here:
>
> http://www.postgresql.org/docs/8.0/interactive/functions- 
> sequence.html#FUNCTIONS-SEQUENCE-TABLE
>
> Sean
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


-- 
Edmund Bacon <ebacon@onesystem.com>



pgsql-sql by date:

Previous
From: Sean Davis
Date:
Subject: Re: getting back autonumber just inserted
Next
From: Don Drake
Date:
Subject: Determining Rank