Re: variable filename for psql \copy - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: variable filename for psql \copy
Date
Msg-id CAKFQuwYM5Z7iz6gLVwgxvxfsN=DwUtkPmcdsTqyPKbjWt-mnfA@mail.gmail.com
Whole thread Raw
In response to variable filename for psql \copy  (Jiří Fejfar <jurafejfar@gmail.com>)
Responses Re: variable filename for psql \copy
List pgsql-hackers
On Mon, Apr 25, 2022 at 1:24 AM Jiří Fejfar <jurafejfar@gmail.com> wrote:
contrib_regression=# copy (select 1) to :'afile';

Hopefully you realize that COPY is going to place that file on the server, not send it to the psql client to be placed on the local machine.

The best way to do copy in psql is:
\set afile '...'
\o :'afile'
copy ... to stdout; --or the variant where you one-shot the \o ( \g with arguments )

Not only do you get variable expansion but you can write the COPY command on multiple lines just like any other SQL command.

Additionally, we have a list, and even an online form, for submitting bug reports.  That would have been the more appropriate place to direct this email.

David J.

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: bogus: logical replication rows/cols combinations
Next
From: Nathan Bossart
Date:
Subject: Re: [Proposal] vacuumdb --schema only