Hi Team,
We are getting below error while during import the csv file please do the
needful.
CREATE TABLE ujshjk ( pod_id bigint NOT NULL, src_id smallint, eff_strt_dt
date,eff_end_dt date,ins_dt timestamp without time zone,updt_dt timestamp
without time zone,nat_key_1 character(50),nat_key_2 character(50),nat_key_3
character(50),nat_key_4 character(50),nat_key_5 character(50));
-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..."
postgres=#
postgres=#
--
Thanks,
Prakash.R
