Hello.
I confess knowing nothing about MS Excel, don't run Windows, never use
it.
Anyway, I am often enough having to load Pg databases using SQL COPY
from CSV output written by Excel, that I've had to write a script to
change the quoting behavior from Excel's putting double quotes around
a field having embedded delim chars, to Pg's backslash quoting.
I've got a hunch that one or both of the aforementioned softwares can
change their quoting behavior. (IT just seems reasonable... famous
last words.)
Is it true that neither of Pg SQL \copy and/or Excel can adapt as I
wish? What about psql \copy? I fail to read in the docs for the Pg
products any support for this.
If Excel can adapt, at least one experienced user I've asked, doesn't
know about it.
Thanks.
--
-------------------------------------------------------------------------------
Jerry Sievers 305 854-3001 (home) WWW ECommerce Consultant 305
321-1144 (mobile http://www.JerrySievers.com/
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
