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