Re: Problem running script

On 9:50 am 07/30/08 "Ian Lea"  wrote:
> $ psql -whatever < test.sql > test.log

Also
psql -f  > 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.