Обсуждение: logging "raise" to file

Hi,

is there a way to log output from "raise ..." to a local file? \o file does not work (for me).

regards
walter

Hi,

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

Thank Georg,

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 --