Re: pg_dump/psql < db.out issue

Michael Davis <mdavis(at)sevainc(dot)com> writes:
> 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.

Huh? That's worked just fine for a long time. What version are you
running?

play=> select * from foo;
f1
----------
I'm here
(1 row)

play=> \q
$ pg_dump -t foo play >quote.sql
$ cat quote.sql
\connect - tgl
CREATE TABLE "foo" (
"f1" text
);
COPY "foo" FROM stdin;
I'm here
\.
$ psql play
Welcome ...
play=> drop table foo;
DROP
play=> \i quote.sql
You are now connected as new user tgl.
CREATE
play=> select * from foo;
f1
----------
I'm here
(1 row)

play=>

regards, tom lane