Postgres Pro
Downloads
Home   >   mailing lists

Re: count of databases by role/user - Mailing list pgsql-novice

From Luca Ferrari
Subject Re: count of databases by role/user
Date
Msg-id CAKoxK+7Q30wBmOynZR3u8HRqnSD5+yGTsoUBfu=-gU1NS826KA@mail.gmail.com
Whole thread Raw
In response to count of databases by role/user  (Pascal Cloup <ptpas059@gmail.com>)
Responses Re: count of databases by role/user  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Tree view 
On Mon, May 11, 2015 at 10:46 AM, Pascal Cloup <ptpas059@gmail.com> wrote:
> Hello,
>
> How to know, programmaticaly, the number of databases/objects depending on a
> user?
>

For databases I would join pg_database and pg_authid, for objects
pg_class and pg_authid.

Hope this helps.
Luca

pgsql-novice by date:

Previous
From: Pascal Cloup
Date:
Subject: count of databases by role/user
Next
From: Tom Lane
Date:
Subject: Re: count of databases by role/user