While not relaying on external tools (eg pg_dump) is exactly why HeidiSQL is so great, I agree with @pashagolub that in this case it might solve bunch of problems and still allow to use Heidi for ...
Steps to reproduce this issue Open HeidiSQL Select PostgreSQL (TCP/IP) Enter the hostname, user, password Click the down arrow by the Database textbox, and it will show you the list of databases on ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results