On Mon, Aug 5, 2013 at 6:22 PM, P. Broennimann <peter.broennimann@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
