pg_dump/psql < db.out issue

From: Michael Davis <mdavis(at)sevainc(dot)com>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: pg_dump/psql < db.out issue
Date: 2001-01-02 09:46:27
Message-ID: 01C07466.38039920.mdavis@sevainc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Anthony E . Greene 2001-01-02 14:30:25 Re: pg_dump/psql < db.out issue
Previous Message rhampton 2001-01-02 07:40:48 Re: Fw: Redundant databases/real-time backup

Browse pgsql-general by date

  From Date Subject
Next Message Gordan Bobic 2001-01-02 10:01:58 Re: SV: MySQL and PostgreSQL speed compare
Previous Message Gordan Bobic 2001-01-02 09:46:16 Re: MySQL and PostgreSQL speed compare