Re: Getting the current value of a sequence

From: amulsul <sul_amul(at)yahoo(dot)co(dot)in>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Getting the current value of a sequence
Date: 2015-04-23 13:13:33
Message-ID: 1429794813502-5846538.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message john kaabi 2015-04-30 11:21:06 Using postgreSQL in our clinic
Previous Message Roxanne Reid-Bennett 2015-04-23 13:12:26 Re: Getting the current value of a sequence