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

From Marcus Engene
Subject copy expensive local view to an RDS instance
Date
Msg-id 5368DB12.20004@engene.se
Whole thread Raw
Responses Re: copy expensive local view to an RDS instance
List pgsql-general
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



pgsql-general by date:

Previous
From: Tim Kane
Date:
Subject: DDL statement blocked on long-running query with no runtime dependancy
Next
From: Tom Lane
Date:
Subject: Re: DDL statement blocked on long-running query with no runtime dependancy