Search Postgresql Archives

Re:

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks a lot. I will check and let you know.

Regards,
Prakash.R

On Tue, Jul 2, 2019 at 1:15 PM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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



--
Thanks,
Prakash.R
PostgreSQL - Offshore DBA support TCS / Nielsen Infrastructure Team On call : +91-8939599426

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux