Re: sequence current value

I tried this. I created a sequence, and ran last_value, then nextval,
repeatedly. last_value always returned 20 until nextval returned 21, then
last_value returned 40 and kept returning 40 until nextval returned 41, etc.

On Fri, May 14, 2021 at 9:39 AM Dave Page <dpage(at)pgadmin(dot)org> wrote:

>
>
> On Fri, May 14, 2021 at 3:33 PM Michael Shapiro <mshapiro51(at)gmail(dot)com>
> wrote:
>
>> How does PgAdmin get the current value of a sequence when showing the
>> sequence properties?
>>
>
> SELECT last_value FROM <sequence_name>;
>
> (essentially. It gets a few other things as well)
>
> --
> Dave Page
> Blog: https://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EDB: https://www.enterprisedb.com
>
>