On Tue, 28 Aug 2007, Chris Hoover wrote:
> Why go through all of this when COPY can handle this for you? All I need to
> know is the syntax to tell copy that the strings are quoted by a single
> quote.
Check out the docs here:
http://www.postgresql.org/docs/8.1/interactive/sql-copy.html
Probably you want to try something like:
COPY foo FROM '/tmp/foo' WITH CSV QUOTE AS '\'';
--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954