editing file after pg_dump

From: Kevin Heflin <kheflin(at)shreve(dot)net>
To: "PGSQL-General (E-mail)" <pgsql-general(at)postgreSQL(dot)org>
Subject: editing file after pg_dump
Date: 1999-03-18 19:27:54
Message-ID: Pine.LNX.4.04.9903181324270.31546-100000@mercury.shreve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I've run pg_dump on a database, which I've done many times before, to
backup and then restore databases.

However, this time before I restore the database, I'm wanting to edit one
of the datatypes before I restore the data. As soon as I open up the file
then save it, regardless of actually making any changes.. the restore will
fail whenever it gets to the point of inserting the data.

I'm guessing it's choking because whatever text editor I'm using is hosing
the fields with long entries... I've tried opening the file with vi, pico,
and Homesite on a WindowsNT box..

Any suggestions on how to get around this?

Kevin

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Heflin 1999-03-18 19:52:23 Re: [GENERAL] editing file after pg_dump
Previous Message Terry Mackintosh 1999-03-18 18:14:36 Re: [ADMIN] delete data