Thread: [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
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
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