On 9:50 am 07/30/08 "Ian Lea" <ian.lea@gmail.com> wrote:
> $ psql -whatever < test.sql > test.log
Also
psql -f <filename> > test.log
Almost the same as above..
> > =>\i test.sql \o test
That would be wrong.
Say you had test.sql
select * from mytable;
You can change test.sql to:
\o test.log
select * from mytable;
Then you could do \i test.sql and accomplish what you are trying to do.
If your DB has passwords enable you may need to put the user/password combo
in .pgpass.