SELECT *
    FROM dblink('dbname=postgres', 'select proname, prosrc from pg_proc')
    AS t1(proname name, prosrc text);

ОШИБКА:  could not establish connection
DETAIL:  fe_sendauth: no password supplied

********** Ошибка **********

ОШИБКА: could not establish connection
SQL-состояние: 08001
Подробности: fe_sendauth: no password supplied