While the main pgadmin console lets me define multiple connections to the same server in different roles, the SQL query window will not let me select them. Once I've selected a connection as a specific role (say, postgres:5488), then I cannot ever select a differently-roled connection as a different user (say, db_admin:5488) to the same database.
I think this is probably simply a deficiency in the connection selector in the SQL window, which only displays IP:Port instead of the list of named connections available in the main console. Can anyone suggest a workaround? --Josh Berkus -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support