I am running Postgresql version 9.3 on Ubuntu. I am wondering if there is a way to run a select statement stored in a script on a Postgres database and then send the results to csv. I know how to do either of the two by themselves; for example, exporting to csv (with the query explicitly written out):

COPY(select * from mytable) to 'path/to/file.csv' with csv header;

and running an sql script:

\i 'myscript.sql'

But after searching around I could not figure out how to do both in one action. That is, I could not figure out how to export to a csv when running a query script rather than typing out a select statement manually.