Re: [GENERAL] import CSV file to a table - Mailing list pgsql-general

From Karl Czajkowski
Subject Re: [GENERAL] import CSV file to a table
Date
Msg-id 20170308163625.GB12449@moraine.isi.edu
Whole thread Raw
In response to Re: [GENERAL] import CSV file to a table  (Rob Sargent <robjsargent@gmail.com>)
Responses Re: [GENERAL] import CSV file to a table
Re: [GENERAL] import CSV file to a table
List pgsql-general
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 by date:

Previous
From: Rob Sargent
Date:
Subject: Re: [GENERAL] import CSV file to a table
Next
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Unable to start postgresql