On 8/27/07, qinghuamail-postgresqlfans(at)yahoo(dot)com
> I use COPY cmd to import large data to database,but I have a question,
> when occured the first error, It always stopped, I need it to be
> continue,and reject the error rows to a file, how to do this?
There are two common ways to do this.
First, import to a temp table then fix up the data there until an
"insert into real_table select * from temp_table" type statement to
import the data.
The second is to swrite some kind of app in bash, perl, php, awd, sed,
C or whatever language you like to put the data into a format that the
database won't choke on.
In response to
pgsql-admin by date
|Next:||From: Robert Treat||Date: 2007-08-27 21:42:57|
|Subject: how is pitr replay interruption time determined?|
|Previous:||From: Neil Peter Braggio||Date: 2007-08-27 21:28:29|
|Subject: Re: Problems connecting to postgres using JDBC Driver.|