On Tue, May 15, 2018 at 8:30 AM, Rhys A.D. Stewart <rhys.stew...@gmail.com> wrote:
> Greetings, > > I have a query in a .sql file and I'd like to use \i to execute it and > \copy to save it to a csv file. Is there any way to combine the two? > > Something along the lines of: > > \copy \i myquery.sql to 'output.csv' > Maybe try something like: \o output.csv COPY ( \i myquery.sql ) TO stdout; \o You'll need to use COPY if you want to mix in \i with a query that would otherwise operate as a standard select query. David J.
