Le 08/10/2019 à 12:55, Daniel Verite a écrit :
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.
I'm on 11.5-1 on the client side, but I had added an output redirection
for this batch file to try to understand what was happening during the
night runs, and that might be the reason why \g fails (i.e. some
interference between the console redirections).
I'll give it another try without these redirections.
Regards
--
Arnaud