Postgres Pro
Downloads
Home   >   mailing lists

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

From Alvaro Herrera
Subject Re: how to load text file that has embeded nul character
Date
Msg-id 20081216131810.GE4741@alvh.no-ip.org
Whole thread Raw
In response to how to load text file that has embeded nul character  (Sun Dong <dongdongsun@yahoo.com>)
List pgsql-general
Tree view 
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 text field or
similar, the data will be truncated at that point; if you want the data
after the NUL to be preserved, you'll need a bytea field (or change the
NUL to something else).

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Adam Witney
Date:
Subject: Is this a security risk?
Next
From: Alvaro Herrera
Date:
Subject: Re: what happens to indexes when TRUNCATEing