Skip site navigation (1) Skip section navigation (2)

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

From: mike lane <mike(dot)lane(at)houndline(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: how to get pg_dump in postgesql 8.2 to create inserts with E'....' for back slashes
Date: 2007-07-05 10:33:15
Message-ID: 200707051233.15323.mike.lane@houndline.com (view raw or flat)
Thread:
Lists: pgsql-novice
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

Responses

pgsql-novice by date

Next:From: Steve LefevreDate: 2007-07-05 13:35:44
Subject: Update with aggregate subquery?
Previous:From: Tom LaneDate: 2007-07-05 04:08:23
Subject: Re: Postgres not using indices defined on my table with certain queries using "in"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group