how to load text file that has embeded nul character

From: Sun Dong <dongdongsun(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to load text file that has embeded nul character
Date: 2008-12-11 22:21:33
Message-ID: 831572.88587.qm@web30905.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Phillip Berry 2008-12-12 00:29:25 Re: Startup process thrashing
Previous Message Joshua D. Drake 2008-12-11 19:46:10 Re: Data Replication