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
--------------------------------------------------------------------