Re: copy notice

From: jtp <john(at)akadine(dot)com>
To: my <muratmy(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: copy notice
Date: 2002-02-21 20:32:49
Message-ID: Pine.BSF.4.21.0202211528130.28816-100000@db.akadine.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Personal experience says one of your fields in that line has a control
character or quite possibly a | itself. causing copy to read that field
as more than one field. Check those lines for odd characters.

The rows will load succesfully, but will truncate whatever it thinks is
'extra'. You should to edit those specific lines and get rid of
whatever's cuasing that error in order to claim everything is imported the
way your pipe delimitted file suggests it should be.

.jtp

> Hi ,
> I load a | delimited text file into a table using the following command :
> copy table_name from '/usr/local/pgsql/table_name.dat' using delimiters '|';
>
> and get this notice for each row :
>
> NOTICE: copy: line 21579, CopyReadNewline: extra fields ignored
>
> but the rows are loaded succesfully, why do I get this notice ?
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Michel POURE 2002-02-21 20:34:48 Re: PostgreSQL GUI?
Previous Message PG Explorer 2002-02-21 20:32:29 Re: PostgreSQL GUI?