This has worked for me in the past:
select schemaname, sequencename, last_value
from pg_sequences;
Thank you,
Nisarg
On Wed, Feb 21, 2024, 5:14 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Campbell, Lance" <lance(at)illinois(dot)edu> writes:
> > Is there a way to get a list of all sequences, the schema it is used in,
> and the current sequence number in use?
>
> Try something like
>
> select relname, relnamespace::regnamespace, pg_sequence_last_value(oid)
> from pg_class where relkind = 'S';
>
> regards, tom lane
>
>
>