From: | brian <brian(at)zijn-digital(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: COPY quote must be a single ASCII character |
Date: | 2008-02-08 16:53:26 |
Message-ID: | 47AC8906.3070608@zijn-digital.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Andrej Kastrin wrote:
>
> Colin Wetherbee wrote:
>> Andrej Kastrin wrote:
>>> ||5354235||,||some text...|| ||1234567||,||some text...||
>>> ||1234568||,||some text...||
>>>
>>> The sql statement I defined was:
>>>
>>> COPY testtable FROM 'test.txt' WITH DELIMITER AS ',' CSV QUOTE AS
>>> '||';
>>>
>>> but the error:
>>>
>>> ERROR: COPY quote must be a single ASCII character
>>
>> I guess I'm stating the obvious here, but can you just change your
>> '||' quotes to a single character within the file?
>>
>> Colin
>>
> The answer is simple no. I know I can to some preprocessing on input
> files using awk, sed etc. but don't want to change the structure of
> the file.
OK, how about replacing '||' with '|' on a *copy* of your file, then?
It's not making that big a change to the structure, in any case.
Otherwise, you won't be able to do what it is that you wish to do. The
delimiter must be a single character, full stop.
brian
From | Date | Subject | |
---|---|---|---|
Next Message | Bryan Murphy | 2008-02-08 17:34:02 | full text index and most frequently used words |
Previous Message | Tom Lane | 2008-02-08 16:28:48 | Re: hyperthreading and pqlib |