How to get the value in the lastvalue field

["Venki" <Venki@xxxxxxxxxx>]

 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