Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] editing file after pg_dump - Mailing list pgsql-general

From Kevin Heflin
Subject Re: [GENERAL] editing file after pg_dump
Date
Msg-id Pine.LNX.4.04.9903181351370.31546-100000@mercury.shreve.net
Whole thread Raw
In response to Re: [GENERAL] editing file after pg_dump  ("Ross J. Reedstrom" <reedstrm@rice.edu>)
List pgsql-general
Tree view 
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
--------------------------------------------------------------------

pgsql-general by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: Re: [GENERAL] editing file after pg_dump
Next
From: "Jonathan A. Zdziarski"
Date:
Subject: Macintosh Drivers