Re: How to get back the current count of a auto incrementing number.

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
To: sid tow <siddy_tow(at)yahoo(dot)com>
Cc: psql mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get back the current count of a auto incrementing number.
Date: 2005-01-28 11:58:48
Message-ID: F831E2CB-7123-11D9-B36B-000D933565E8@mail.nih.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Jan 28, 2005, at 6:36 AM, sid tow wrote:

> hi
>
> How to get the current value of a auto
> incrementing number generated using CREATE SEQUENCE
> seqname START 1
>
> Is there any way and if yes what is it. Can we run a
> select query and may be a inbuilt function which will
> return the current value of that number?

Look at:

http://www.postgresql.org/docs/8.0/interactive/functions-sequence.html

Sean

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mike Rylander 2005-01-28 12:02:00 Re: Splitting queries across servers
Previous Message Shridhar Daithankar 2005-01-28 11:58:33 Re: How to get back the current count of a auto incrementing number.