| From: | Craig Ringer <craig(at)postnewspapers(dot)com(dot)au> |
|---|---|
| To: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
| Subject: | \COPY ... CSV with hex escapes |
| Date: | 2010-07-08 02:21:19 |
| Message-ID: | 4C35361F.2020208@postnewspapers.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi folks
I have an odd csv input format to deal with. I'm about to put some
Python together to reprocess it, but I thought I'd check in and see if
I'm missing something obvious in \copy's capabilities.
The input is fairly conventional comma-delimeted text with quoted
fields, as output by Sybase SQL Anywhere 5.5's isql 'OUTPUT TO' filter.
Yes, that's ancient. It is handled quite happily by \copy in csv mode,
except that when csv mode is active, \xnn escapes do not seem to be
processed. So I can have *either* \xnn escape processing *or* csv-style
input processing.
Anyone know of a way to get escape processing in csv mode?
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Hunsberger | 2010-07-08 02:37:30 | Re: \COPY ... CSV with hex escapes |
| Previous Message | Craig Ringer | 2010-07-08 01:45:00 | Re: Problems with Vista and Windows 7 |