psql's \copy incompatible with :variables

From: The Fuzzy Chef <fuzzy(at)fuzzychef(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: psql's \copy incompatible with :variables
Date: 2011-06-07 23:18:40
Message-ID: 4DEEB1D0.4080503@fuzzychef.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Summary: \copy interprets psql's :variables as literal strings

Tested On: 8.4.4, 9.0.4

Severity: Annoyance

Steps to Reproduce:

psql

\set filename 'test.csv'

\copy pg_class to :filename with csv

\q

ls

:filename

Note that psql variables work perfectly fine with COPY. It's just \copy
which seems to be misbehaving.

--Josh

Browse pgsql-bugs by date

  From Date Subject
Next Message Josh Berkus 2011-06-08 00:22:23 psql's \copy incompatible with :variables
Previous Message Robert Haas 2011-06-07 22:06:18 Re: BUG #6041: Unlogged table was created bad in slave node