Postgres Pro
Downloads
Home   >   mailing lists

COPY from a remote machine in Datastage - Mailing list pgsql-general

From Ravi Krishna
Subject COPY from a remote machine in Datastage
Date
Msg-id EB01BE67-FA95-4E66-9FC0-0F2B1219A4D1@aol.com
Whole thread Raw
In response to Re: Does postgreSQL community edition supports data distributionacross nodes  (James Keener <jim@jimkeener.com>)
Responses Re: COPY from a remote machine in Datastage  (Josef Šimánek <josef.simanek@gmail.com>)
Re: COPY from a remote machine in Datastage  (Edmundo Robles <edmundo@sw-argos.com>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: Durumdara
Date:
Subject: Prevent locked state (row lock + alter table)
Next
From: Josef Šimánek
Date:
Subject: Re: COPY from a remote machine in Datastage