RE: How to find all current sequence IDs
| От | Campbell, Lance |
|---|---|
| Тема | RE: How to find all current sequence IDs |
| Дата | |
| Msg-id | SJ0PR11MB562929E58B465C88D275156ADE5F2@SJ0PR11MB5629.namprd11.prod.outlook.com обсуждение исходный текст |
| Ответ на | Re: How to find all current sequence IDs (Nisarg Patel <er.nisarg@gmail.com>) |
| Список | pgsql-sql |
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 по дате отправления: