Re: bytea and character encoding when inserting escaped literals

From: Asche <asche(dot)public(at)mac(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: bytea and character encoding when inserting escaped literals
Date: 2008-05-05 15:21:16
Message-ID: 8601FB54-F21A-43B8-B028-71C899EFBD2B@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Lee,

On 05.05.2008, at 17:07, Lee Feigenbaum wrote:
> INSERT INTO myTable VALUES (..., E'\x15\x1C\x2F\x00\x02...', ...) ;

try escaping the backslashes:

INSERT INTO myTable VALUES (..., E'\\x15\\x1C\\x2F\\x00\\x02...', ...) ;

Jan

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Myers 2008-05-05 15:26:22 Re: Custom C function - is palloc broken?
Previous Message Scott Marlowe 2008-05-05 15:08:05 Re: COPY Performance