On Mon, 8 Apr 2002, 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.
In psql use \l to get the list of databases and SELECT * FROM pg_user; to get
user information.
--
Nigel J. Andrews
Director
---
Logictree Systems Limited
Computer Consultants