pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Edmund Bacon <ebacon@onesystem.com>
To: pgsql-sql@postgresql.org
Subject: Re: getting back autonumber just inserted
Date: Thu, 03 Feb 2005 15:53:20 -0700
Message-ID: <4202AB60.90608@onesystem.com> (raw)
In-Reply-To: <B878A549-7631-11D9-AFCC-000D933565E8@mail.nih.gov>
References: <5d14ecf90410162019443dc355@mail.gmail.com>
	<4202A2A3.7070707@dri.edu>
	<B878A549-7631-11D9-AFCC-000D933565E8@mail.nih.gov>

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>




view thread (30+ messages)  latest in thread

Message-ID: <4202AB60.90608@onesystem.com>
Permalink:  ../4202AB60.90608@onesystem.com/
Also on:    postgresql.org/message-id/4202AB60.90608@onesystem.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: ebacon@onesystem.com
  Subject: Re: getting back autonumber just inserted
  In-Reply-To: <4202AB60.90608@onesystem.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox