Re: psql \copy hanging

On 10/7/19 12:41 AM, Arnaud L. wrote:
> 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 you are saying that you have not run the problematic line by itself?

>
> So, still apparently random...
>> 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".

I was not paying attention, thanks for the heads up.

>
> Regards
> --
> Arnaud
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com