Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] More newbie question: Restructuring a table - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: [GENERAL] More newbie question: Restructuring a table
Date
Msg-id Pine.GSO.4.02A.10003021649460.27493-100000@Dront.DoCS.UU.SE
Whole thread Raw
In response to More newbie question: Restructuring a table  (Timothy Grant <tjg@avalongroup.net>)
List pgsql-general
Tree view 
On Wed, 1 Mar 2000, Timothy Grant wrote:

> Is there a quick and dirty way that I am missing for creating a new
> database with a slightly different schema than the old db?

pg_dump lets you dump out the schema only. Try that, edit it to your taste
and read it back in with psql (into the new database).


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden

pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Simple problem?
Next
From: Peter Eisentraut
Date:
Subject: Re: [GENERAL] Performance on WindowsNT