Re: COPY formatting - Mailing list pgsql-hackers

From Joshua D. Drake
Subject Re: COPY formatting
Date
Msg-id 405A2276.4090105@commandprompt.com
Whole thread Raw
In response to Re: COPY formatting  (Josh Berkus <josh@agliodbs.com>)
Responses Re: COPY formatting
List pgsql-hackers
>
> And, BTW, I deal with CSV *all the time* for my insurance clients, and I can
> tell you that that format hasn't changed in 20 years.   We can hard-code it
> if it's easier.

Well many of my clients consider CSV "Character Separated Value" not
Comma... Thus I get data like this:

"Hello","Good Bye"
Hello    Good Bye
Hello,Good Bye
"This", "They're"
This    They're
"This"    "Is"    "A"    1


Dealing with all of these different nuances is may or may not be beyond
the scope of copy but it seems that it could be something that it can
handle.

Python has a csv module that allows you to assign dialects to any
specific type of import you are performing.

Sincerely,

Joshua D. Drake



>


--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL

Attachment

pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Authentication drop-down?
Next
From: Jonathan Gardner
Date:
Subject: Bug in CVS HEAD on bootparse.y???