Re: COPY TO duplicates "\" signs - Mailing list pgsql-general

From Ivan Sergio Borgonovo
Subject Re: COPY TO duplicates "\" signs
Date
Msg-id 20081105160157.2f7eb00e@dawn.webthatworks.it
Whole thread Raw
In response to COPY TO duplicates "\" signs  ("Abraham, Danny" <danny_abraham@bmc.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_casts view (was Re: date_trun() with timezones? (was Re: TIME column ...))
Next
From: "Shashank Mujumdar"
Date:
Subject: Error in starting Postgresql...