Re: psql \copy hanging

Le 04/10/2019 à 19:08, Adrian Klaver a écrit :
> On 10/4/19 12:19 AM, Arnaud L. wrote:
>> OK I can do that. I thought I nailed it down to this line because it
>> started failing when this line was ~5th in the script, and it kept
>> failing on that very same line after I moved it at the very end of the
>> script (that's where it is now).
>
> Which tends to point to it as the problem. The question is whether it
> exhibits that behavior on its own or only when in combination with the
> other commands.

Yes. It ran fine this last night. I had moved the line back to its
original place, so now everything is exactly like it was before it
started showing this behaviour.

So, still apparently random...

>> 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.
>
> Yeah not sure how that is supposed to work:
>
[...]
> production_(postgres)# \copy (select * from cell_per) TO STDOUT \g
> 'cell.txt'
> ERROR: syntax error at or near "\"
> LINE 1: COPY ( select * from cell_per ) TO STDOUT \g 'cell.txt'

This works with real SQL commands, so it should be "COPY" here, not "\copy".

Regards
--
Arnaud