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

From Albe Laurenz
Subject Re: COPY TO duplicates "\" signs
Date
Msg-id D960CB61B694CF459DCFB4B0128514C202B55152@exadv11.host.magwien.gv.at
Whole thread Raw
In response to COPY TO duplicates "\" signs  ("Abraham, Danny" <danny_abraham@bmc.com>)
List 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

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Equivalent for AUTOINCREMENT?
Next
From: Tom Lane
Date:
Subject: Re: pg_casts view (was Re: date_trun() with timezones? (was Re: TIME column ...))