Re: Error while importing CSV file

From: Alban Hertroys <haramrae(at)gmail(dot)com>
To: Lockas <w_ward_w(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Error while importing CSV file
Date: 2012-02-06 12:34:39
Message-ID: CAF-3MvNhRN_OR7Lewqw8YX7fDsC=TYTHXGpUCpztev8ry_03Og@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6 February 2012 13:26, Lockas <w_ward_w(at)hotmail(dot)com> wrote:
> *
> ok then if I want to except that row from copying. how i can write it ?*

You can either remove the offending line(s) from the csv file or copy
to a staging table that doesn't have those limitations on field
lengths first.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Fanbin Meng 2012-02-06 13:52:23 Backup database remotely
Previous Message David Johnston 2012-02-06 12:32:57 Re: Error while importing CSV file