Re: COPY TO duplicates "\" signs

From: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY TO duplicates "\" signs
Date: 2008-11-05 15:01:57
Message-ID: 20081105160157.2f7eb00e@dawn.webthatworks.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, 5 Nov 2008 05:06:36 -0600
"Abraham, Danny" <danny_abraham(at)bmc(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shashank Mujumdar 2008-11-05 15:04:55 Error in starting Postgresql...
Previous Message Tom Lane 2008-11-05 14:59:30 Re: pg_casts view (was Re: date_trun() with timezones? (was Re: TIME column ...))