Thread: Turning Off PotgrSQL Output Messages

I have tried different options to turnoff the output mode of psql (turning off the STDERR & STDOUT and redirecting it to another file), and I have not been successful. The steps I have taken to capture the output of my script in an output file using the ‘\o’ option, are as follows:

# \o error_log \i script.sql

To provide more background, I have a wrapper “sql” code that launches a few other “sql” scripts, and I start it as follows at the PSQL level:

# \o wrapper_log_out \i wrapper.sql

Within the wrapper.sql script, I have the following lines (which unsuccessfully attempt to turnoff PostgreSQLcapture scripts:

\o createTable_log_out   \i createTableScript

\o insertTable_log_out    \i insertTableScript

…as it is obvious, I have placed all of my Table creations within the “createTableScript”, and all of my insert statements in the “insertTableScript”. Incidentally, initially within the ‘wrapper.sql’ script all I had were the following lines, and that option did not work either:

\i  createTableScript

\i  insertTableScript

Any suggestions as to how to go about this issue?

Thanks,

Behzad