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@xxxxxxxxxxxxxxxxxxxxxx> Frost Consulting, LLC http://www.frostconsultingllc.com/ Phone: 650-780-7908 FAX: 650-649-1954 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
