Re: Cryptic Error Message Importing Table Dump

On Thursday, September 15, 2011 6:24:42 am Rich Shepard wrote:
> On Thu, 15 Sep 2011, Alban Hertroys wrote:

>
> Each row terminates with a \n; when the cursor is at the row end and I
> press ctrl-f (move one character forward), the cursor is at the beginning
> of the next line.
>
> I'm confused about your statement that a tab is not valid for the 'real'
> column. There are tabs between that column and adjacent ones, but no tabs
> within any text column (only one of which has multiple strings).
>
> Could the error be far from the reported line 47363 but that's where
> psql stopped? I've not been able to think of a way to check the entire
> file for an extra tab as the length of each column's content varies.
>
> Still perplexed,

In your editing of the file did you happen to edit out the \.
that is at the end of the COPY data?

>
> Rich

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com