I am copying data from a CSV file using the query noted below. Many
items in my CSV file contain the double quotes in the field (i.e., '20"
COLOR MONITOR'). This field imports as, '""20"" COLOR MONITOR""'. How
do I remove all those extra quotes? Also, should I be using the STDIN
parameter or is my query below sufficient?



COPY item_master

(id, description, unit_measure, mfg, product_line)

FROM 'c:/item_test1.csv'

using delimiters ','

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedOct 21, '08 at 3:35p
activeOct 21, '08 at 3:35p
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Scott Porter: 1 post

People

Translate

site design / logo © 2021 Grokbase