Re: How to list databases with SQL statement?

On Nov 19, 2004, at 7:39 PM, Marian D Marinov wrote:

> Hello,
> Is there a way to list all databases which belong to the current user
> with an
> SQL query?


select datname, usename
    from pg_catalog.pg_database, pg_catalog.pg_user
    where datdba = usesysid and usename = current_user;


Best,

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL