Re: ERROR: COPY quote must be a single ASCII character

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Andrej Kastrin" <andrej(dot)kastrin(at)siol(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: ERROR: COPY quote must be a single ASCII character
Date: 2008-02-08 20:00:12
Message-ID: dcc563d10802081200t3c838e73o395fdfca8d69593@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Feb 8, 2008 9:06 AM, Andrej Kastrin <andrej(dot)kastrin(at)siol(dot)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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hua-Ying Ling 2008-02-08 20:50:02 installing in another directory
Previous Message Teodor Sigaev 2008-02-08 18:35:38 Re: full text index and most frequently used words