Re: how to get pg_dump in postgesql 8.2 to create inserts with E'....' for back slashes

From: Jim Nasby
Subject: Re: how to get pg_dump in postgesql 8.2 to create inserts with E'....' for back slashes
Date: ,
Msg-id: FF782F2A-8AD0-42D6-9AE7-2229896CAFBE@decibel.org
(view: Whole thread, Raw)
In response to: how to get pg_dump in postgesql 8.2 to create inserts with E'....' for back slashes  (mike lane)
List: pgsql-novice

On Jul 5, 2007, at 5:33 AM, mike lane wrote:
> I have been trying to get postgresql 8.2 to create sql insert
> commands which,
> for a field of type byteA with back-slashes, are in the form E'xxx
> \yy\zz'
>
> I assume that the same cannot be done with postgresql versions 7.
>
> I have found how to turn off the warning if the insert used a back-
> slash as an
> escape character (ie. in the form 'xxx\\yy\\zz').
>
> I am in the process of changing from version 7.4 to 8.2 and from
> what I
> understand the correct way to have the insert is without the escape
> back-slash.

Use the 8.2 version of pg_dump and you should be fine, at least on
escapes.
--
Jim Nasby                                            
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)




pgsql-novice by date:

From: Jim Nasby
Date:
Subject: Re: how to get pg_dump in postgesql 8.2 to create inserts with E'....' for back slashes
From: "Ashish Karalkar"
Date:
Subject: Re: Windows XP Install Problem