Re: copy expensive local view to an RDS instance

[bricklen <bricklen@xxxxxxxxx>]

On Tue, May 6, 2014 at 5:52 AM, Marcus Engene <mengpg2@xxxxxxxxx> wrote:

Hi,

I have a local db behind a firewall etc. Basically, I'd like to do what I'd locally would...

create table abc
as
select
    *
from
    local_expensive_view;

abc - on RDS
local_expensive_view - on local machine

How would you go about doing this?

Thanks,
Marcus

A very quick search shows that rds supports dblink, so perhaps that would work.
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html