Обсуждение: [help] Is it possible to support remote COPY operation on PG?

Поиск
Список
Период
Сортировка

[help] Is it possible to support remote COPY operation on PG?

От
"Xiong He"
Дата:
Is it possible to copy some table data from remote client to the PG database server directly without upload the data file to the server side in advance?

---------------------------------------------------
Thanks&Regards,
Xiong He

 

Re: [help] Is it possible to support remote COPY operation on PG?

От
Dann Corbit
Дата:

You can use the libpq API:

http://www.postgresql.org/docs/9.2/interactive/libpq-copy.html

 

The Postgresql JDBC driver exposes COPY, IIRC.

 

 

From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Xiong He
Sent: Tuesday, October 23, 2012 11:55 PM
To: PostgreSQL-development
Subject: [HACKERS] [help] Is it possible to support remote COPY operation on PG?

 

Is it possible to copy some table data from remote client to the PG database server directly without upload the data file to the server side in advance?

---------------------------------------------------

Thanks&Regards,

Xiong He

 

Re: [help] Is it possible to support remote COPY operation on PG?

От
Michael Paquier
Дата:


On Wed, Oct 24, 2012 at 3:54 PM, Xiong He <iihero@qq.com> wrote:
Is it possible to copy some table data from remote client to the PG database server directly without upload the data file to the server side in advance?
With a psql client you can use the command ¥copy to perform that.
--
Michael Paquier
http://michael.otacoo.com