On Tue, May 6, 2014 at 5:52 AM, Marcus Engene <mengpg2(at)engene(dot)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