RE: Capturing all output from psql into a file

Assuming you are on Linux/Unix:

psql YOURDBNAME -e < sqlscript.txt > output.txt 2>&1

The -e option echos the script too which is helpful when debugging.

On NT do this:

(see Q110930 for more info)

psql YOURDBNAME -e < sqlscript.txt 1> output.txt 2>&1

--rob

----------
From: Huy Do [SMTP:huy(at)travel(dot)com(dot)au]
Sent: Wednesday, December 20, 2000 12:37 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: Capturing all output from psql into a file

Hi,

I am doing this mass table creation (approx 600 tables) and then
mass dump of records into these tables (~900megs of flat files).

All the table creation and record copy is being done from a file
using \i sqlscript.txt.

How can I capture all the output which comes out from psql. I need
all the errors and not just the query result.

I have tried to use \o file.txt and \g file.txt but they only
seem to output the query result.

Many thanks.

Huy