Re: [ADMIN] checking currval

[Jodi Kanter]

Title: ________________________________

I tried that and it did not work. It won't be a problem in the code since it appears that we are always doing a nextval prior to currval, but I was just wondering about how to do it while in a psql session.

Weiping He wrote:

select last_value from your_sequence;

Jodi Kanter wrote:

I cannot view the currval because it is not set in the session yet. Is there a way to set it without having to increment the value?
Thanks
Jodi

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
[EMAIL PROTECTED]