Search Postgresql Archives

Re: Cryptic Error Message Importing Table Dump

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxx

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux