If you are on unix just run $ psql -whatever < test.sql > test.log
Don't know about Windows. -- Ian. On Fri, Jul 25, 2008 at 6:20 PM, Sushma Sagaram <[EMAIL PROTECTED]> wrote: > My requirement is > 1) to write a query in a file, read the input from that file, run in > postgresql and write the output(query results) into a file. I'm not able to > use combination of \i and \o > Let' say I have file test.sql and in test.sql I write > select * from abc; > Now I need to read the query from the file and write the output to a file. > I tried > =>\i test.sql \o test > but that is not working. I want to write a script which reads query from > file and write output in a file and I want to do everything in one script > and run it background at a particular time of teh day. > 2) How do I run scripts in postgresql? How do I set the shell and execute > the script? > > Regards, > Sushma > > -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
