Postgres Pro
Downloads
Home   >   mailing lists

Re: how to get list of sequences owned by a user/role - Mailing list pgsql-general

From Adrian Klaver
Subject Re: how to get list of sequences owned by a user/role
Date
Msg-id 876646ab-9c3b-f226-4e8b-d404c3ea27be@aklaver.com
Whole thread Raw
In response to how to get list of sequences owned by a user/role  (Charlin Barak <charlinbarak@gmail.com>)
Responses Re: how to get list of sequences owned by a user/role  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: ERROR could not access transaction/Could not open file pg_commit_ts
Next
From: Adrian Klaver
Date:
Subject: Re: how to get list of sequences owned by a user/role