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

From: Charlin Barak <charlinbarak(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to get list of sequences owned by a user/role
Date: 2018-03-09 20:08:33
Message-ID: CAPrg5caqz-LEJ-PzhiGQ6eS5MNJ7=-H-c1Jh_7hEM=U5gU-4WQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Thanks.

Charlin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jerry Sievers 2018-03-09 20:24:38 Re: ERROR could not access transaction/Could not open file pg_commit_ts
Previous Message Alvaro Herrera 2018-03-09 18:40:52 Re: ERROR could not access transaction/Could not open file pg_commit_ts