[ADMIN] Copy cmd error

2007-08-27 Thread qinghuamail-postgresqlfans
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! - 雅虎邮箱,以安全著称,是值得信赖的邮箱专家!

转发: [ADMIN] Copy cmd error

2007-08-27 Thread qinghuamail-postgresqlfans
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 error 收件人: p

[ADMIN] 回复: [ADMIN] {Spam} 转发: [ADMIN] Copy cmd error

2007-08-28 Thread qinghuamail-postgresqlfans
thanks ,i read the source of pgloader,and have decided to rewrite my perl script. thanks again. - 原始邮件 发件人: Dimitri Fontaine <[EMAIL PROTECTED]> 收件人: pgsql-admin@postgresql.org; [EMAIL PROTECTED] 已发送: 2007/8/28(周二), 下午4:03:57 主题: Re: [ADMIN] {Spam} 转发: [ADMIN] Copy cmd error Hi, Le

[ADMIN] how to create dir using pg/plsql

2007-08-28 Thread qinghuamail-postgresqlfans
just subject, i need to create dir using pg/plsql function,,but cannt get anything after google, please advise? thanks! - 雅虎邮箱,以安全著称,是值得信赖的邮箱专家!

回复: Re: [ADMIN] how to create dir using pg/plsql

2007-08-29 Thread qinghuamail-postgresqlfans
oh,i see, thank you very much! hubert depesz lubaczewski <[EMAIL PROTECTED]> 写道: On Wed, Aug 29, 2007 at 02:45:56PM +0800, [EMAIL PROTECTED] wrote: > just subject, > i need to create dir using pg/plsql function,,but cannt get anything after > google, it's not possible. pl/pgsql is trusted langu