Search Postgresql Archives

Sequence Manipulation Functions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

 

 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux