Re: COPY TO duplicates "\" signs

On Wed, 5 Nov 2008 05:06:36 -0600
"Abraham, Danny" <danny_abraham@bmc.com> wrote:

> Hi,
>
> String in DB:
>
> D:\Program Files\BMC Software\CONTROL-D\wa/reports
>
> In the output files "\| are duplicated: The string in the output
> text fileis
> D:\\Program Files\\BMC Software\\CONTROL-D\\wa/reports
>   ==             ==            ==         ==

try to play with the ESCAPE AS and set it as '' if you really want
to skip \.

http://www.postgresql.org/docs/8.1/static/sql-copy.html

--
Ivan Sergio Borgonovo
http://www.webthatworks.it