Re: How to find all current sequence IDs - Mailing list pgsql-sql

From Nisarg Patel
Subject Re: How to find all current sequence IDs
Date
Msg-id CAA=RfSPoPw0ERRGEQTVGYvAzJjES42At0bhxCNvW1x_LnAu0nw@mail.gmail.com
Whole thread Raw
In response to Re: How to find all current sequence IDs  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses RE: How to find all current sequence IDs  ("Campbell, Lance" <lance@illinois.edu>)
List pgsql-sql
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@sss.pgh.pa.us> wrote:
"Campbell, Lance" <lance@illinois.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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: How to find all current sequence IDs
Next
From: Cars Jeeva
Date:
Subject: PG_DUMP ERROR