Postgres Pro
Downloads
Home   >   mailing lists

COPY: how to use "," as a delimeter? - Mailing list pgsql-general

From Jean-Christian Imbeault
Subject COPY: how to use "," as a delimeter?
Date
Msg-id 3D50CC69.1040401@mega-bucks.co.jp
Whole thread Raw
List pgsql-general
Tree view 
I have a CSV file that I would like ti import into pgsql. Unfortunately
the data has been exported in the following format:

"filed1","filed2","field3"

furthemore the data also contains the odd " (quote) and in the CSV file
it has been turned into "".

How can I import this data? I have tried COPY but can't find the right
delimeter to use ...

Thanks,

Jc

pgsql-general by date:

Previous
From: frbn
Date:
Subject: Re: select all groups a user belongs to in system tablesl
Next
From: frbn
Date:
Subject: Re: COPY: how to use "," as a delimeter?