Re: [SQL] Selecting Current value from a sequence

[George Moga]

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 -:).
>

Try:

SELECT last_value FROM sequence_name;


> Regards, Najm

For me works (PostgreSQL 7.0.3, Mandrake Linux 7.2).

George Moga,
    Data Systems Srl
    Slobozia, ROMANIA