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

From: PFC <lists(at)boutiquenumerique(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to get back the current count of a auto incrementing number.
Date: 2005-01-28 12:26:44
Message-ID: opslbbiuwuth1vuj@musicbox
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


This question pops about once a day...
can't the list server grep for "auto increment" and send a link to the
docs itself ;)

> 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?
>
> Regards.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Kings-Lynne 2005-01-28 13:46:00 MySQL worm attacks Windows servers
Previous Message Mike Rylander 2005-01-28 12:02:00 Re: Splitting queries across servers