Re: How do I list all users and all databases.

On Mon, 2002-04-08 at 16: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.

SELECT * FROM pg_user;

SELECT * FROM pg_database; (or, in psql, \l)

--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C

"And they questioned Him, saying "...Is it lawful for
us to pay taxes to Caesar, or not? ...And He said to
them "...render to Caesar the things that are
Caesar's, and to God the things that are God's."
Luke 20:21,22,25