> 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
>
=> \o test
and then
=> \i test.sql
But this is not related to pgadmin. You should have ask on pgsql-general.
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
No comments:
Post a Comment