Re: how to get list of sequences owned by a user/role

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: how to get list of sequences owned by a user/role
Дата
Msg-id 876646ab-9c3b-f226-4e8b-d404c3ea27be@aklaver.com
обсуждение исходный текст
Ответ на how to get list of sequences owned by a user/role  (Charlin Barak <charlinbarak@gmail.com>)
Ответы Re: how to get list of sequences owned by a user/role
Список pgsql-general
Дерево обсуждения 
On 03/09/2018 12:08 PM, Charlin Barak wrote:
> Hi,
> I can find sequences owned by a schema from information_schema.sequences 
> and pg_class but how do I find sequences owned by a user/role? What pg 
> table should I be looking at?

https://www.postgresql.org/docs/10/static/view-pg-sequences.html

> 
> Thanks.
> 
> Charlin


-- 
Adrian Klaver
adrian.klaver@aklaver.com

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

Предыдущее
От: Jerry Sievers
Дата:
Сообщение: Re: ERROR could not access transaction/Could not open file pg_commit_ts
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: how to get list of sequences owned by a user/role