if you have ssh access to the client, you can do :
ssh user(at)client_host "cat /path_to/large_file.csv" | psql -d database
....
On Fri, Oct 5, 2018 at 9:06 AM Ravi Krishna <srkrishna1(at)aol(dot)com> wrote:
>
> We are doing a POC of using Datastage with PG using ODBC.
>
> Problem to solve: How to load a large CSV file using COPY command. The
> file is on the client machine.
>
> A typical SQL syntax of a copy coming from a remote machine COPY TABLE
> FROM STDIN WITH CSV HEADER
>
> Question is, how to make the contents of the file available as STDIN in a
> SQL. It is easy in a shell.
>
--