Bruce Momjian <br...@momjian.us> writes: > Josh Berkus wrote: >> Note that psql variables work perfectly fine with COPY. It's just \copy >> which seems to be misbehaving.
> The problem is that none of the backslash commands interpret variables: Nonsense. regression=# \set foo bar regression=# \d foo Did not find any relation named "foo". regression=# \d :foo Did not find any relation named "bar". \copy is different because it uses OT_WHOLE_LINE mode to read the argument, and that doesn't expand :variable references. I'd be a bit leery of changing that. regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs