Using COPY command when input file contain backslashes?

From: Celia McInnis <celia(dot)mcinnis(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Using COPY command when input file contain backslashes?
Date: 2005-09-13 17:05:50
Message-ID: 11c334a2050913100554f34f2e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm wanting to use the COPY command to bulk-load data which may contain
backslashes and other special characters, and I want these characters to
remain intact. Right now "\\" becomes "\", and single backslashes are lost
(or modify the meaning of the following character). Is there some way (apart
from pre-processing my (huge) input files) to get the data correctly into
postgres?
Thanks for your help,
Celia McInnis

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2005-09-13 17:36:00 full outer join performance
Previous Message Steve Atkins 2005-09-13 16:57:09 Re: Email Verfication Regular Expression