Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeffrey W. Baker
Subject Re: How do I list all users and all databases.
Date
Msg-id 1018903882.27420.4.camel@heat
Whole thread Raw
In response to How do I list all users and all databases.  (MattStan <mattstan@blueyonder.co.uk>)
List pgsql-general
Tree view 
On Mon, 2002-04-08 at 08:09, MattStan wrote:
> Hi everyone,
>
> During testing of my postgresql install I created several users and
> 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
> work out how to do this. Thanks for your help.

I don't know how to list users but 'psql -l' lists databases -jwb

pgsql-general by date:

Previous
From: Gunther Schadow
Date:
Subject: Re: Mass-Data question
Next
From: Timothy Wood
Date:
Subject: Re: using CAST and LIKE