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