Postgres Pro
Downloads
Home   >   mailing lists

Re: sequence current value - Mailing list pgadmin-support

From Michael Shapiro
Subject Re: sequence current value
Date
Msg-id CAGCvxea6DrrDRO77k4M4Zb-Nqy-gMmjz_5UR4ji3rnut+fdU8A@mail.gmail.com
Whole thread Raw
In response to Re: sequence current value  (Dave Page <dpage@pgadmin.org>)
Responses Re: sequence current value
List pgadmin-support
Tree view
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@pgadmin.org> wrote:


On Fri, May 14, 2021 at 3:33 PM Michael Shapiro <mshapiro51@gmail.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)

--

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: sequence current value
Next
From: dsbw
Date:
Subject: Re: Import fails on single quote.