I don't use Postgres to do this but I have done something similar with DBD::ODBC and MS SQL Server. With DBD::ODBC, the messages output are passed to the odbc_err_handler (if you define one). Perhaps DBD::Pg has something similar.