Postgres Pro
Downloads
Home   >   mailing lists

psql's \copy incompatible with :variables - Mailing list pgsql-bugs

From The Fuzzy Chef
Subject psql's \copy incompatible with :variables
Date
Msg-id 4DEEB1D0.4080503@fuzzychef.org
Whole thread Raw
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Anton Dedov
Date:
Subject: Re: ON DELETE CASCADE with multiple paths in PostgreSQL 9.x
Next
From: "Sav"
Date:
Subject: BUG #6055: connection refused