Is there a way to export the output of an arbitrary SQL query to a
quoted CSV file?
It seems that the COPY command can do that for regular tables (COPY foo
TO STDOUT WITH CSV QUOTE AS '"') but not for a query result. I could
create temp tables in a script but it seems that there should be a
simpler alternative.
The command-line psql can obviously be used with an arbitrary query, but
seems to fail on the quoting part--am I missing some option to psql that
would put quotes around fields that contain the quote character,
newlines, etc.?
What I am looking for is essentially a command-line alternative to the
pgAdmin export's "quoting" options.
George