Specifically I want to see if I can retrieve RAISE INFO messages that I use to see progress in the console.
Are these stored somewhere in pg?
Whether messages of a particular priority are reported to the client, written to the server log, or both is controlled by the log_min_messages and client_min_messages configuration variables.