Re: count of databases by role/user

From: Luca Ferrari <fluca1978(at)infinito(dot)it>
To: Pascal Cloup <ptpas059(at)gmail(dot)com>
Cc: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: count of databases by role/user
Date: 2015-05-11 09:46:30
Message-ID: CAKoxK+7Q30wBmOynZR3u8HRqnSD5+yGTsoUBfu=-gU1NS826KA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Mon, May 11, 2015 at 10:46 AM, Pascal Cloup <ptpas059(at)gmail(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2015-05-11 13:51:14 Re: count of databases by role/user
Previous Message Pascal Cloup 2015-05-11 08:46:56 count of databases by role/user