Re: Selecting Current value from a sequence

From: clayton cottingham <drfrog(at)smartt(dot)com>
To: Najm Hashmi <najm(at)mondo-live(dot)com>
Cc: "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Selecting Current value from a sequence
Date: 2001-01-18 18:37:43
Message-ID: 3A6737F7.A21FECA0@smartt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Najm Hashmi wrote:
>
> Hi all,
> It is a very simple but I am not able to recall how to do it.... I
> just need to find out the current value of a seq. It is very simple
> select statement but I can't recall it... Help me please before I get
> myself get fired -:).
> Regards, Najm

select nextval('nameofseq');

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2001-01-18 18:50:35 Re: Selecting Current value from a sequence
Previous Message Bruce Momjian 2001-01-18 18:23:23 Re: Selecting Current value from a sequence