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 <[email protected]> wrote: > > > On Fri, May 14, 2021 at 3:33 PM Michael Shapiro <[email protected]> > 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 > >
