COPY from a remote machine in Datastage

From: Ravi Krishna <srkrishna1(at)aol(dot)com>
To:
Cc: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: COPY from a remote machine in Datastage
Date: 2018-10-05 14:05:56
Message-ID: EB01BE67-FA95-4E66-9FC0-0F2B1219A4D1@aol.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Josef Šimánek 2018-10-05 14:12:25 Re: COPY from a remote machine in Datastage
Previous Message Durumdara 2018-10-05 12:55:01 Prevent locked state (row lock + alter table)