COPY: how to use "," as a delimeter?

Поиск
Список
Период
Сортировка
От Jean-Christian Imbeault
Тема COPY: how to use "," as a delimeter?
Дата
Msg-id 3D50CC69.1040401@mega-bucks.co.jp
обсуждение исходный текст
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: frbn
Дата:
Сообщение: Re: select all groups a user belongs to in system tablesl
Следующее
От: frbn
Дата:
Сообщение: Re: COPY: how to use "," as a delimeter?