On Mon, Aug 5, 2013 at 6:22 PM, P. Broennimann
<peter(dot)broennimann(at)gmail(dot)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