Sun Dong wrote:
When I tried to load it, I always get this error:
invalid byte sequence for encoding UTF8: 0x00
how could I load this into postgresql database?
I'm afraid you'll have to preprocess the file to convert the 0x00 into
\000. Obviously, if you're inserting this file into a
Hi there,
I have to use copy command to load a text file. One of the filed contains an
embeded nul character.
as shown in the attached file.
When I tried to load it, I always get this error:
invalid byte sequence for encoding UTF8: 0x00
how could I load this into postgresql database?