On Fri, Oct 21, 2011 at 7:24 AM, Richard Huxton <d...@archonet.com> wrote: > 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 ===
I'm not sure whether that's a bug per se, but I can see where a behavior change might be an improvement. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
