How to find all current sequence IDs

Поиск
Список
Период
Сортировка
От Campbell, Lance
Тема How to find all current sequence IDs
Дата
Msg-id SJ0PR11MB562974ADFAF0F0CFB72A8B6DDE572@SJ0PR11MB5629.namprd11.prod.outlook.com
обсуждение исходный текст
Ответы Re: How to find all current sequence IDs
Список pgsql-sql

Is there a way to get a list of all sequences, the schema it is used in, and the current sequence number in use?

 

The below SQL will give me the schema and sequences. It does not give me the current sequence number in use.

 

SELECT sequence_schema, sequence_name

FROM information_schema.sequences

ORDER BY sequence_name ;

 

Thanks,

 

Lance Campbell

University of Illinois

В списке pgsql-sql по дате отправления: