RE: How to find all current sequence IDs

That worked great. Thanks so much.

From: Nisarg Patel <er(dot)nisarg(at)gmail(dot)com>
Sent: Wednesday, February 21, 2024 5:17 PM
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Campbell, Lance <lance(at)illinois(dot)edu>; pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: How to find all current sequence IDs

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<mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>> wrote:
"Campbell, Lance" <lance(at)illinois(dot)edu<mailto: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