Re: pgsql and streams

Поиск
Список
Период
Сортировка
От Tino Wildenhain
Тема Re: pgsql and streams
Дата
Msg-id 442B9FB7.8040304@wildenhain.de
обсуждение исходный текст
Ответ на Re: pgsql and streams  ("Christopher Condit" <condit@sdsc.edu>)
Список pgsql-general
Christopher Condit schrieb:
> Back to this thread - I realize that in the "COPY TO" documentation, it
> states the CSV file used for loading must be on the server's disk.  If I
> can't put files on the server's disk, I'm curious if I can use the STDIN
> option from my JDBC client to load the data to the server?  Using psql I
> can stream data after the call. Is there anyway to accomplish the same
> thing with JDBC?
>

Not sure about JDBC but you can in fact stream your data to COPY via
STDIN - which is the network socket of your database connection.

I'm using this with python for example.

Regards
Tino

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

Предыдущее
От: "Christopher Condit"
Дата:
Сообщение: Re: pgsql and streams
Следующее
От: "Sergey Karin"
Дата:
Сообщение: How to detect primary key of a table