Horton

Re: [GENERAL] editing file after pg_dump

Kevin Heflin <kheflin@shreve.net>

View thread View on postgr.es
From: Kevin Heflin <kheflin@shreve.net>
To: "Ross J. Reedstrom" <reedstrm@rice.edu>
Cc: "PGSQL-General (E-mail)" <pgsql-general@postgresql.org>
Date: 1999-03-18T19:52:23Z
Lists: pgsql-general 
On Thu, 18 Mar 1999, Ross J. Reedstrom wrote:

> you might try dumping the schema and data separately:
> 
> pg_dump -a yourdb >yourdb.data
> pg_dump -s yourdb >yourdb.schema
> 
> then edit the schema without touching the data, then
> 
> psql newdb <yourdb.schema
> psql newdb <yourdb.data
> 

Thanks for the tip.. I'll try that.


Kevin



--------------------------------------------------------------------
Kevin Heflin          | ShreveNet, Inc.      | Ph:318.222.2638 x103
VP/Mac Tech           | 333 Texas St #619    | FAX:318.221.6612
kheflin@shreve.net    | Shreveport, LA 71101 | http://www.shreve.net
--------------------------------------------------------------------