Re: COPY from a remote machine in Datastage

Hello, if you need to use COPY command from remote machine and you use some
libpq bindings (aka ruby pg gem for example), you can use functions
associated with COPY command (
https://www.postgresql.org/docs/10/static/libpq-copy.html). They should be
provided by bindings of postgres library you're using.

If you can share more info, at least how do you access postgres (via Ruby
gem for example or from client's console), I can try to be more descriptive.

Josef

pá 5. 10. 2018 v 16:06 odesílatel Ravi Krishna <srkrishna1(at)aol(dot)com> napsal:

>
> 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.
>