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