Postgres Pro
Downloads
Home   >   mailing lists

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

From Campbell, Lance
Subject RE: How to find all current sequence IDs
Date
Msg-id SJ0PR11MB562929E58B465C88D275156ADE5F2@SJ0PR11MB5629.namprd11.prod.outlook.com
Whole thread Raw
In response to Re: How to find all current sequence IDs  (Nisarg Patel <er.nisarg@gmail.com>)
List pgsql-sql
Tree view

That worked great. Thanks so much.

 

From: Nisarg Patel <er.nisarg@gmail.com>
Sent: Wednesday, February 21, 2024 5:17 PM
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Campbell, Lance <lance@illinois.edu>; pgsql-sql@lists.postgresql.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@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: Cars Jeeva
Date:
Subject: PG_DUMP ERROR
Next
From: intmail01
Date:
Subject: How to know if all insertions are finished