Home:ALL Converter>Copy file from Remote Server using PgAdmin4

Copy file from Remote Server using PgAdmin4

Ask Time:2022-05-17T00:40:49         Author:Msilvy

Json Formatter

I am trying to copy a file from my Office Remote server as CSV output on my local machine (windows). I cannot use the export/import dialog. It shows the following error

Utility file not found. Please correct the Binary Path in the Preferences dialog

The same command works fine for local server files meaning I have already edited the binary path in the Configuration setting.

The COPY command gives the following error

ERROR: relative path not allowed for COPY to file SQL state: 42602

\Copy doesn't work either.

Can anyone suggest me a solution for this?

Author:Msilvy,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/72262698/copy-file-from-remote-server-using-pgadmin4
yy