Re: ERROR: COPY quote must be a single ASCII character - Mailing list pgsql-general

From Scott Marlowe
Subject Re: ERROR: COPY quote must be a single ASCII character
Date
Msg-id dcc563d10802081200t3c838e73o395fdfca8d69593@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: COPY quote must be a single ASCII character  (Andrej Kastrin <andrej.kastrin@siol.net>)
List pgsql-general
On Feb 8, 2008 9:06 AM, Andrej Kastrin <andrej.kastrin@siol.net> wrote:
> 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.

If the problem is that you have | characters in your data, then can
you change the || to \t (tabs) for this load?  Or some other
character?

pgsql-general by date:

Previous
From: valgog
Date:
Subject: Re: Execute
Next
From: "Hua-Ying Ling"
Date:
Subject: installing in another directory