psql's \copy incompatible with :variables

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема psql's \copy incompatible with :variables
Дата
Msg-id 4DEEC0BF.7030105@agliodbs.com
обсуждение исходный текст
Ответы Re: psql's \copy incompatible with :variables
Список 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 Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

В списке pgsql-bugs по дате отправления: