thanks ,i read the source of pgloader,and have decided to rewrite my perl
script.
thanks again.
- 原始邮件
发件人: Dimitri Fontaine <[EMAIL PROTECTED]>
收件人: [email protected]; [EMAIL PROTECTED]
已发送: 2007/8/28(周二), 下午4:03:57
主题: Re: [ADMIN] {Spam} 转发: [ADMIN] Copy cmd err
Hi,
Le mardi 28 août 2007, [EMAIL PROTECTED] a écrit :
> hi, after reading the source of pgloader,i have a idea,use perl to create
> the flat file, and, when error,reject the row,seek the next line,continue
> to copy.
That's pretty much what pgloader already does for you: if COPY errors out,
pgl
hi, after reading the source of pgloader,i have a idea,use perl to create the
flat file, and, when error,reject the row,seek the next line,continue to copy.
thanks everyone.
[EMAIL PROTECTED] 写道: 日期: Mon, 27 Aug 2007 16:18:35 +0800 (CST)
发件人: <[EMAIL PROTECTED]>
主题: [ADMIN] Copy cmd err
On 8/27/07, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
> hi,all
>
> 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 way
Hi,
Le lundi 27 août 2007, [EMAIL PROTECTED] a écrit :
> 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?
You can try out pgloader, which has
hi,all
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?
thanks!
-
雅虎邮箱,以安全著称,是值得信赖的邮箱专家!