Re: psql \copy hanging

From: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
To: arnaud(dot)listes(at)codata(dot)eu
Cc: "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>,"pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: Re: psql \copy hanging
Date: 2019-10-08 10:55:57
Message-ID: f228a10f-748d-4da1-9aad-6ae81b9c48c9@manitou-mail.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Arnaud L. wrote:

> As a side note, COPY (...) TO STDOUT \g 'somefile' does not work in a
> script file (i.e. it does not work if the command is passed in a file
> via the -f argument).
> The command runs fine, no error is raised either by the client or the
> server, but no file is written.

Testing this with 11.5, it works for me.
Make sure you're running the latest minor release (on the client
side in this case), because a related fix was issued last February.
For the 11 branch it was in version 11.2.

Best regards,
--
Daniel Vérité
PostgreSQL-powered mailer: http://www.manitou-mail.org
Twitter: @DanielVerite

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arnaud L. 2019-10-08 11:12:21 Re: psql \copy hanging
Previous Message Timmy Siu 2019-10-08 10:50:31 GPS coordinates problem