PostgreSQL copies the data into the table - Copy, data, PostgreSQL, table, will

I use the copy command in Postgresql, I have a line of data in a text file, it is the separator, I want to copy it to the db table.

I received an error saying:
Error: Invalid byte sequence encoding “UTF8”: 0x00
SQL status: 22021
Context: COPY real_acct1, line 113038

< p>So I went from the text file to line 113038 and copied it along with 4 or 5 adjacent lines into a new text file and saw the new data come in.

Any useful idea? This is parcel data attribute information.

Your question is actually one of the character encodings. < p>

The easiest way to deal with this problem is to run import data through iconv (assuming you are using a unix machine).

iconv -f original_charset -t utf-8 originalfile> New file

I use the copy command in Postgresql, I have a line of data in a text file, it is the delimiter, and I want to copy it into the db table.

I received an error saying:
Error: Invalid byte sequence encoding “UTF8”: 0x00
SQL status: 22021
Context: COPY real_acct1, No. 113038 Line

So I went from the text file to line 113038 and copied it along with 4 or 5 adjacent lines into a new text file and saw the new data enter.

Any useful ideas? This is parcel data attribute information.

Your problem is actually one of the character encodings.

Handle this problem The easiest way is to run the import data through iconv (assuming you are using a unix machine).

iconv -f original_charset -t utf-8 originalfile>new file