copy expensive local view to an RDS instance

From: Marcus Engene <mengpg2(at)engene(dot)se>
To: POSTGRESQL <pgsql-general(at)postgresql(dot)org>
Subject: copy expensive local view to an RDS instance
Date: 2014-05-06 12:52:34
Message-ID: 5368DB12.20004@engene.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2014-05-06 14:05:32 Re: DDL statement blocked on long-running query with no runtime dependancy
Previous Message Tim Kane 2014-05-06 11:46:51 DDL statement blocked on long-running query with no runtime dependancy