Skip site navigation (1) Skip section navigation (2)

use copy command!

From: feng xinguo <feng(dot)xinguo(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: use copy command!
Date: 2007-08-27 08:17:07
Message-ID: 590927.22426.qm@web58111.mail.re3.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
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!

       
---------------------------------
雅虎邮箱,以安全著称,是值得信赖的邮箱专家! 

pgsql-admin by date

Next:From: qinghuamail-postgresqlfansDate: 2007-08-27 08:18:35
Subject: Copy cmd error
Previous:From: Tom LaneDate: 2007-08-25 22:51:53
Subject: Re: reindexdb hangs

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group