pg_dump/psql < db.out issue - Mailing list pgsql-admin

From Michael Davis
Subject pg_dump/psql < db.out issue
Date
Msg-id 01C07466.38039920.mdavis@sevainc.com
Whole thread Raw
Responses Re: pg_dump/psql < db.out issue
Re: pg_dump/psql < db.out issue
List pgsql-admin
I have several tables with text fields that contain single quotes (').
 Pg_dump exports these tables and the single quotes (') okay.  Psql,
however, will not import the data into the tables because of the single
quote (') in one of the columns in one of the records.  Any idea how to
work around this other than using the -d/-D option in pg_dump?  I like the
-d option in pg_dump, however, importing the data via pgsql is much slower
with this option.

Thanks in advance, Michael Davis



pgsql-admin by date:

Previous
From: "rhampton"
Date:
Subject: Re: Fw: Redundant databases/real-time backup
Next
From: "Anthony E . Greene"
Date:
Subject: Re: pg_dump/psql < db.out issue