Sequence Manipulation Functions

Поиск
Список
Период
Сортировка
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

NameLast valueIncrement byMax valueMin valueCache valueLog countIs cycled?Is called?
adr_dsnr108192233720368547758071125NoYes

So how can I get that information?

Thanks

Michaela

 

 

В списке pgsql-general по дате отправления: