export-import problem - Mailing list pgsql-general

From GreyGeek
Subject export-import problem
Date
Msg-id _gggd.8486$Df1.511@twister.rdc-kc.rr.com
Whole thread Raw
Responses Re: export-import problem
List pgsql-general
I export data from a table that contains a varchar field that stores  whole
names in it.  Some of the names include the apostrophe character....
O'Neal, etc...  When I attempt to import the data (using the copy command
the apostrophe kills the import.  If I export the data with quotes around
the varchar field the quotes get stored inside the varchar field.
What the magic incantation to get apostrophes in textual data without
surrounding the data with quotes?
--
--
GreyGeek

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Daylight Savings Time handling on persistent connections
Next
From: Marco Colombo
Date:
Subject: Re: Reasoning behind process instead of thread based