I have debugging messages in functions. Those message are raised like
RAISE NOTICE 'Value of id : %', id;
I set my log file with
Then I do what I need to do with
And when the execution is terminated,
The problem is that I don't have the messages raised by notices into messages.txt. The messages are displayed on the screen but I want them to be written in messages.txt
How could I do that ?
I tried to use
RAISE LOG... and messages are written in log file... It's not what I want.
I have a work around with
plsql -f /path/to/process.sql > messages.txt 2>&1
but I would like to know how I could use \i and \o on plsql client having the messages into the file specified in \o
My client, on cygwin is psql (PostgreSQL) 8.2.11 and the server version is 9.0.7