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 по дате отправления:

Предыдущее
От: Cars Jeeva
Дата:
Сообщение: PG_DUMP ERROR
Следующее
От: intmail01
Дата:
Сообщение: How to know if all insertions are finished