Postgres Pro
Downloads
Home   >   mailing lists

how to load text file that has embeded nul character - Mailing list pgsql-general

From Sun Dong
Subject how to load text file that has embeded nul character
Date
Msg-id 831572.88587.qm@web30905.mail.mud.yahoo.com
Whole thread Raw
Responses Re: how to load text file that has embeded nul character  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Tree view 
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?

Thanks.
Dong

pgsql-general by date:

Previous
From: Ketema
Date:
Subject: Re: View vs Constantly Updated Table
Next
From: "Jonathon Suggs"
Date:
Subject: Re: Query Question (one group by vs two separate)