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

From: Shridhar Daithankar <ghodechhap(at)ghodechhap(dot)net>
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:33
Message-ID: 200501281728.33827.ghodechhap@ghodechhap.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 28 Jan 2005 5:06 pm, 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?

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

HTH

Shridhar

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sean Davis 2005-01-28 11:58:48 Re: How to get back the current count of a auto incrementing number.
Previous Message Csaba Nagy 2005-01-28 11:56:58 Re: How to get back the current count of a auto