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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
