Re:

Yes, CSV stands for comma separated variable length. This means that the
fields in each row should be separated by commas, with a carriage return at
the end of each record. You have a file using | separators, which mean it
is not csv.

On Tue, Jul 2, 2019 at 6:04 PM <raf(at)raf(dot)org> wrote:

> Laurenz Albe wrote:
>
> > On Tue, 2019-07-02 at 13:09 +0530, Prakash Ramakrishnan wrote:
> > > We are getting below error while during import the csv file please do
> the needful.
> >
> > I'd say the needful thing here is for you to read the documentation...
> >
> > > -bash-4.2$ more ckr_sto.csv
> > > 4937880 | 12 | 2015-01-05 | | 2015-01-05 05:51:47 |
> | | 5000128790679 | | | |
> > > 4939355 | 12 | 2015-01-05 | | 2015-01-05 05:51:47 |
> | | 5000128639345 | | | |
> > > 4939744 | 12 | 2015-01-05 | | 2015-01-05 05:51:47 |
> | | 5000128684510 | | | |
> > > 4939750 | 12 | 2015-01-05 | | 2015-01-05 05:51:47 |
> | | 5000128683100 | | | |
> > > 4936360 | 12 | 2015-01-05 | | 2015-01-05 05:51:47 |
> | | 5000128567527 | | | |
> > > 4940308 | 12 | 2015-01-05 | | 2015-01-05 05:51:47 |
> | | 5000128781329 | | | |
> > > 4938006 | 12 | 2015-01-05 | | 2015-01-05 05:51:47 |
> | | 4000128912554 | | | |
> > > 4937457 | 12 | 2015-01-05 | | 2015-01-05 05:51:47 |
> | | 5000128426574 | | | |
> > >
> > > error
> > > ----------
> > > postgres=# \copy ckr_sto from /data/ckr_sto.csv CSV HEADER;
> > > ERROR: invalid input syntax for integer: " 4939355 | 12 |
> 2015-01-05 | | 2015-01-05 05:51:47 | | |
> 5000128639345 | | | | "
> > > CONTEXT: COPY ckr_sto, line 2, column pod_id: " 4939355 | 12 |
> 2015-01-05 | | 2015-01-05 05:51:47 | | |
> 500012863934..."
> >
> > >From the documentation of COPY:
> >
> > DELIMITER
> >
> > Specifies the character that separates columns within each row
> (line) of the file.
> > The default is a tab character in text format, a comma in CSV format.
> > This must be a single one-byte character. This option is not allowed
> when using binary format.
> >
> > Yours,
> > Laurenz Albe
> > --
> > Cybertec | https://www.cybertec-postgresql.com
>
> in other words, ckr_sto.csv is not a csv file.
> it just has .csv at the end of its name.
> that's why psql tried to interpret the entire
> line as the first column: there were no commas.
>
> its contents should look something like:
>
> 4937880,12,2015-01-05,,2015-01-05 05:51:47,,,5000128790679,,,,
> 4939355,12,2015-01-05,,2015-01-05 05:51:47,,,5000128639345,,,,
> 4939744,12,2015-01-05,,2015-01-05 05:51:47,,,5000128684510,,,,
> 4939750,12,2015-01-05,,2015-01-05 05:51:47,,,5000128683100,,,,
> 4936360,12,2015-01-05,,2015-01-05 05:51:47,,,5000128567527,,,,
> 4940308,12,2015-01-05,,2015-01-05 05:51:47,,,5000128781329,,,,
> 4938006,12,2015-01-05,,2015-01-05 05:51:47,,,4000128912554,,,,
> 4937457,12,2015-01-05,,2015-01-05 05:51:47,,,5000128426574,,,,
>
>
>
>

--
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'