Sorry I can not help with PgAdmin. I do not use PgAdmin and would have to install it to try. Installing PgAdmin is not a step I care to take.
The one time I accessed an exported Discourse database was to use install PostgreSQL, odbc-postgresql and use iusql as noted here.