psql \set vs \copy - bug or expected behaviour?
Richard Huxton <dev@archonet.com>
From: Richard Huxton <dev@archonet.com>
To: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2011-10-21T11:24:52Z
Lists: pgsql-hackers
It looks like \copy is just passing the text of the query unadjusted to "COPY". I get a syntax error on ":x" with the \copy below on both 9.0 and 9.1 === test script === \set x '''HELLO''' -- Works \echo :x -- Works \o '/tmp/test1.txt' COPY (SELECT :x) TO STDOUT; -- Doesn't work \copy (SELECT :x) TO '/tmp/test2.txt' === end script === -- Richard Huxton Archonet Ltd