COPY from a remote machine in Datastage

Поиск
Список
Период
Сортировка
От Ravi Krishna
Тема COPY from a remote machine in Datastage
Дата
Msg-id EB01BE67-FA95-4E66-9FC0-0F2B1219A4D1@aol.com
обсуждение исходный текст
Ответ на Re: Does postgreSQL community edition supports data distributionacross nodes  (James Keener <jim@jimkeener.com>)
Ответы 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>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Durumdara
Дата:
Сообщение: Prevent locked state (row lock + alter table)
Следующее
От: Josef Šimánek
Дата:
Сообщение: Re: COPY from a remote machine in Datastage