Thread: how to get pg_dump in postgesql 8.2 to create inserts with E'....' for back slashes
how to get pg_dump in postgesql 8.2 to create inserts with E'....' for back slashes
From
mike lane
Date:
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. thanks mike l
Re: how to get pg_dump in postgesql 8.2 to create inserts with E'....' for back slashes
From
Jim Nasby
Date:
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 jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)