Re: [GENERAL] CSV delim quoting differences PgCOPY, Excel etc...

2005-05-18 Thread Edmund Bacon
[EMAIL PROTECTED] (Jerry Sievers) writes: > Hello. > > 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 deli

Re: [GENERAL] CSV delim quoting differences PgCOPY, Excel etc...

2005-05-17 Thread Sven Willenberger
On Tue, 2005-05-17 at 15:58 -0400, Jerry Sievers wrote: > 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 > cha

[GENERAL] CSV delim quoting differences PgCOPY, Excel etc...

2005-05-17 Thread Jerry Sievers
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 fie