Hi,
Am 28.07.2019 um 12:32 schrieb wambacher(at)posteo(dot)de:
>
> Hi,
>
> is there a way to log output from "raise ..." to a local file? \o file
> does not work (for me).
>
> regards
> walter
>
the red part writes your "raise notice" to your log
psql (+your connection string) -f /path/to/file.sql *>
/path/to/log/xxx.log 2>&1*
see
https://dba.stackexchange.com/questions/107199/how-to-log-custom-messages-from-inside-a-postgresql-transaction
regards
Georg