Try following SQL:
SELECT last_value FROM name_of_sequence;
--
View this message in context: http://postgresql.nabble.com/Getting-the-current-value-of-a-sequence-tp5846523p5846538.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.