Re: How do I list all users and all databases. - Mailing list pgsql-general

From Marin Dimitrov
Subject Re: How do I list all users and all databases.
Date
Msg-id 00ba01c1e480$8c1e5730$9b0e32d4@sirma.bg
Whole thread Raw
In response to How do I list all users and all databases.  (MattStan <mattstan@blueyonder.co.uk>)
List pgsql-general
----- Original Message -----
From: "MattStan"

> databases, now I can't remember exactly what I added. Can someone kindly
> tell me how to list all user names and all databases, I can't seem to
>

select * from pg_database;

select * from pg_user;

see also "System Catalogs" chapter from the Developer's Guide

hth,

    Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "



pgsql-general by date:

Previous
From: google@vrane.com (google)
Date:
Subject: Re: [NOVICE] readline and psql
Next
From: google@vrane.com (google)
Date:
Subject: Re: readline not working on RedHat 7.2