Thread

RE: pg_dump/psql < db.out issue

Michael J Davis <mdavis@sevainc.com> — 2001-01-02T21:31:02Z

Thanks for pointing this out.  I tested this again and it works great.   I 
have been trying to make sure I understand how to recreate a database from 
the dump files.  The error I was seeing must have been caused by something 
else.  Sorry for the trouble and thanks for the response.

-----Original Message-----
From:	Tom Lane [SMTP:tgl@sss.pgh.pa.us]
Sent:	Tuesday, January 02, 2001 9:45 AM
To:	mdavis@sevainc.com
Cc:	'pgsql-admin@postgresql.org'; 'pgsql-general@postgresql.org'
Subject:	Re: pg_dump/psql < db.out issue

Michael Davis <mdavis@sevainc.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