Home > mailing lists

Thread: logging "raise" to file

From

wambacher@posteo.de

Date:

28 July 2019, 13:32:41

Hi,

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

regards
walter

From

Guillaume Lelarge

Date:

28 July 2019, 15:14:34

Hi,

Le dim. 28 juil. 2019 à 12:32, <wambacher@posteo.de> a écrit :

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

No, RAISE messages can only go to log files. You would need to call a function that could write to a file (though without calling RAISE).

Guillaume.

From

"Georg H."

Date:

28 July 2019, 16:57:15

Hi,

Am 28.07.2019 um 12:32 schrieb wambacher@posteo.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

regards

Georg

From

wambacher@posteo.de

Date:

28 July 2019, 19:32:04

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