Re: Combining \i and \copy in psql
От
David G. Johnston
Тема
Re: Combining \i and \copy in psql
Дата
Msg-id
CAKFQuwbRDM1e2+m4MLdYr6wOo1KU8y4CVbbmO5G9A56woFzrHQ@mail.gmail.com
Ответ на
Combining \i and \copy in psql (Rhys A.D. Stewart)
Список
Дерево обсуждения
Combining \i and \copy in psql "Rhys A.D. Stewart" <rhys.stewart@gmail.com>
Re: Combining \i and \copy in psql "David G. Johnston" <david.g.johnston@gmail.com>
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.
В списке pgsql-general по дате отправления
