How to get the value in the lastvalue field

Поиск
Список
Период
Сортировка
 Hi,
Can anyone in the list tell me how to get the value in the lastvalue field of a sequence. I tried

select currval('field_seq');

but got an error message

ERROR:  currval of sequence "field_seq" is not yet defined in this session.

I think currval will work only after an insert. I don't want to use nextval as this increases the lastvalue value.

 

Thanks in advance

Kind Regards,
Venki

 

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