Postgres Pro
Downloads
Home   >   mailing lists

Re: Move Tables From One Database to Another - Mailing list pgsql-general

From Rich Shepard
Subject Re: Move Tables From One Database to Another
Date
Msg-id alpine.LNX.2.00.1203291328010.7215@salmo.appl-ecosys.com
Whole thread Raw
In response to Re: Move Tables From One Database to Another  (Andy Colson <andy@squeakycode.net>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Move Tables From One Database to Another
Next
From: Jonathan Bartlett
Date:
Subject: Re: Managing two sets of data in one database