Select last_value from your_sequence_name;
John
MG wrote:
Hello,
I use PostgreSQL 8.0.3.
I want to get the information of the last value of a sequence.
The function 'currval' only gives the value back, if before a nextval is executed.
Return the value most recently obtained by nextval for this sequence in the current session. (An error is reported if nextval has never been called for this sequence in this session.) Notice that because this is returning a session-local value, it gives a predictable answer whether or not other sessions have executed nextval since the current session did.
But that is not very helpful.
I noticed that the phpPgAdmin has that information
Name Last value Increment by Max value Min value Cache value Log count Is cycled? Is called?
adr_dsnr 108 1 9223372036854775807 1 1 25 No Yes
So how can I get that information?
Thanks
Michaela
