Postgres Pro
Downloads
Home   >   mailing lists

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

From Charlin Barak
Subject how to get list of sequences owned by a user/role
Date
Msg-id CAPrg5caqz-LEJ-PzhiGQ6eS5MNJ7=-H-c1Jh_7hEM=U5gU-4WQ@mail.gmail.com
Whole thread Raw
Responses Re: how to get list of sequences owned by a user/role  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: ERROR could not access transaction/Could not open filepg_commit_ts
Next
From: Jerry Sievers
Date:
Subject: Re: ERROR could not access transaction/Could not open file pg_commit_ts