insert data over dblink from bulk select of local table - Mailing list pgsql-general

From Marcus Engene
Subject insert data over dblink from bulk select of local table
Date
Msg-id 5331912A.6010209@engene.se
Whole thread Raw
Responses Re: insert data over dblink from bulk select of local table
List pgsql-general
Hi,

I have a production database with some heavy views.

I'd like to make a hourly cron (or smth) that bulk inserts new entries
into a table on RDS.

It's easy to get data down to the prod side, but is it possible to do a
bulk insert the other way around? All examples I've seen adds the data
in a litteral way.

Thanks,
Marcus



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange result for full text query
Next
From: Adrian Klaver
Date:
Subject: Re: insert data over dblink from bulk select of local table