insert data over dblink from bulk select of local table

From: Marcus Engene <mengpg2(at)engene(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: insert data over dblink from bulk select of local table
Date: 2014-03-25 14:22:34
Message-ID: 5331912A.6010209@engene.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Frank 2014-03-25 14:49:09 Please ignore my previous mail: piping pg_dump output / solved
Previous Message Tom Lane 2014-03-25 13:56:56 Re: Strange result for full text query