Ryan Kelly <rpkelly22@xxxxxxxxx> writes: > I recently switched from OSX to Linux and \copy in psql no longer > accepts multi-line queries. For instance: > \copy ( > select > * > from > pg_settings > ) to '/tmp/settings.csv' with csv header > This works fine on OSX. On Linux I get: > \copy: parse error at end of line FWIW, I get that error on either OS X or Linux, and I'm a bit astonished by your report that there are any versions of psql that allow it. psql doesn't do multi-line backslash commands, in any context. Are you sure you weren't doing a plain SQL "copy" command, without a backslash? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
