Re: [GENERAL] import CSV file to a table

Поиск
Список
Период
Сортировка
Искать
От
Bret Stern
Тема
Re: [GENERAL] import CSV file to a table
Дата
Msg-id
1488992089.3126.8.camel@bret.machinemanagement.com
Ответ на
Re: [GENERAL] import CSV file to a table (Karl Czajkowski)
Список
Дерево обсуждения
[GENERAL] import CSV file to a table Günce Kaya <guncekaya14@gmail.com>
Re: [GENERAL] import CSV file to a table vinny <vinny@xs4all.nl>
Re: [GENERAL] import CSV file to a table John McKown <john.archie.mckown@gmail.com>
Re: [GENERAL] import CSV file to a table Karl Czajkowski <karlcz@isi.edu>
Re: [GENERAL] import CSV file to a table Rob Sargent <robjsargent@gmail.com>
Re: [GENERAL] import CSV file to a table Karl Czajkowski <karlcz@isi.edu>
Re: [GENERAL] import CSV file to a table Bret Stern <bret_stern@machinemanagement.com>
Re: [GENERAL] import CSV file to a table Rob Sargent <robjsargent@gmail.com>
Re: [GENERAL] import CSV file to a table Karl Czajkowski <karlcz@isi.edu>
Re: [GENERAL] import CSV file to a table Rob Sargent <robjsargent@gmail.com>
Re: [GENERAL] import CSV file to a table Günce Kaya <guncekaya14@gmail.com>
Re: [GENERAL] import CSV file to a table "David G. Johnston" <david.g.johnston@gmail.com>
Re: [GENERAL] import CSV file to a table "Martijn Tonies \(Upscene Productions\)" <m.tonies@upscene.com>
Re: [GENERAL] import CSV file to a table John McKown <john.archie.mckown@gmail.com>
Re: [GENERAL] import CSV file to a table Vick Khera <vivek@khera.org>
I'll throw in.

If tab delimited is available, perhaps that option will work better...or..
use Access to find the violations of the quote comma delimited assumptions, then
export from Access an import

Bret


On Wed, 2017-03-08 at 08:36 -0800, Karl Czajkowski wrote: 
I believe that in its fully glory, you cannot reliably locate CSV
record boundaries except by parsing each field in order including
quote processing.  Individual records may have arbitrary numbers of
field and record separator characters within the values.

Karl


On Mar 08, Rob Sargent modulated:
> Since bash has been bandied about in this thread I presume awk is
> available.  Here's how I would check just how 'csv'ish the incoming
> file is.
> ...

В списке pgsql-general по дате отправления
Предыдущее
От: Karl Czajkowski
Дата:
Следующее
От: Rob Sargent
Дата:
FAQ