Re: copy expensive local view to an RDS instance - Mailing list pgsql-general

From bricklen
Subject Re: copy expensive local view to an RDS instance
Date
Msg-id CAGrpgQ9QYxOgSVN-OWagdoUNGdwDXTpTg4qd5D=dCPgqficVYw@mail.gmail.com
Whole thread Raw
In response to copy expensive local view to an RDS instance  (Marcus Engene <mengpg2@engene.se>)
Responses Re: copy expensive local view to an RDS instance  (Marcus Engene <mengpg2@engene.se>)
List pgsql-general
On Tue, May 6, 2014 at 5:52 AM, Marcus Engene <mengpg2@engene.se> 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

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Server process crash - Segmentation fault
Next
From: Marcus Engene
Date:
Subject: Re: copy expensive local view to an RDS instance