population csv file into sql

Question

COPY population 
FROM '/Users/chittampalliyashaswini/Documents/population.csv'
DELIMITER ',' CSV HEADER;

I tried running this same command. I moved the population csv to the my documents folder.

This is the result I am getting.

ERROR:  invalid byte sequence for encoding "UTF8": 0x00
CONTEXT:  COPY population, line 1
********** Error **********

ERROR: invalid byte sequence for encoding "UTF8": 0x00
SQL state: 22021
Context: COPY population, line 1

Possible duplicate of [Postgres error on insert - ERROR: invalid byte sequence for encoding "UTF8": 0x00](http://stackoverflow.com/questions/1347646/postgres-error-on-insert-error-invalid-byte-sequence-for-encoding-utf8-0x0) — Hambone, Feb 09 '16 at 04:18

score 0 · Answer 1 · edited May 23 '17 at 12:31

In short, there is no simple answer to this question.

As given here and here, this basically is about PostgreSQL's incapability to store a data in the column that you want it to. Ideally you should solve this by going back to the source, and change every instance of such a character and then take a re-dump and use that to restore the target DB once again.

The URLs given above, both give ways to do this, albeit agreeably they aren't very convenient.

population csv file into sql

1 Answers1