Re: dblink / Insert several records into remote table - Mailing list pgsql-general

From Michael Paquier
Subject Re: dblink / Insert several records into remote table
Date
Msg-id CAB7nPqTmHXBStPg8ucE62sH6u32BaTNVMSNEWnv7RmAjKMoROg@mail.gmail.com
Whole thread Raw
In response to dblink / Insert several records into remote table  ("P. Broennimann" <peter.broennimann@gmail.com>)
List pgsql-general
On Mon, Aug 5, 2013 at 6:22 PM, P. Broennimann
<peter.broennimann@gmail.com> wrote:
> Hello
>
> I'd like to use dblink to insert records (several) from a local table to a
> remote table. Is it possible to do this in one statement? Something like:
>
>     insert into <remotetable> select col1, col2, col3 from <localtable>
dblink_exec can be of a certain help in this case. Documentation
provides a couple of examples:
http://www.postgresql.org/docs/9.2/static/contrib-dblink-exec.html
--
Michael


pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Possible bug with row_to_json
Next
From: "ascot.moss@gmail.com"
Date:
Subject: pg_stat_replication became empty suddenly