Re: Move Tables From One Database to Another

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Move Tables From One Database to Another
Date: 2012-03-29 20:28:50
Message-ID: alpine.LNX.2.00.1203291328010.7215@salmo.appl-ecosys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 29 Mar 2012, Andy Colson wrote:

> How many tables are we talking about. If its a few tables, I'd rename them:
> alter table lake rename to lake_old;
> ... etc
> then dump it out and restore into the proper db.

Andy,

This will work just fine. Thanks for the insight.

Rich

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Bartlett 2012-03-29 20:39:38 Re: Managing two sets of data in one database
Previous Message Rich Shepard 2012-03-29 20:27:24 Re: Move Tables From One Database to Another