My requirement is 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 sue 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 this is not working. can any one tell me how to do this. I also need to put my file in a place which can run the file at particualr time of the day(like cron tab). Where do I put my file?
Regards,
sushma