Обсуждение: pg_dump/psql < db.out issue
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
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