Re: COPY TO duplicates "\" signs

From: "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Abraham, Danny *EXTERN*" <danny_abraham(at)bmc(dot)com>, <pgsql-general(at)postgresql(dot)org>
Cc: <dabraham(at)Bmc(dot)com>
Subject: Re: COPY TO duplicates "\" signs
Date: 2008-11-05 14:51:30
Message-ID: D960CB61B694CF459DCFB4B0128514C202B55152@exadv11.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Abraham, Danny wrote:
> 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
> == == == ==
>
> Standard_conforming_strings will not help here.
>
> Any ideas? Help will be appreciated.

Can you reproduce this with psql?

Can you select "length()" of this field (to see if it is 50 characters
long or not)?

How are the output files generated?

Yours,
Laurenz Albe

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-11-05 14:59:30 Re: pg_casts view (was Re: date_trun() with timezones? (was Re: TIME column ...))
Previous Message Albe Laurenz 2008-11-05 14:01:02 Re: Equivalent for AUTOINCREMENT?