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

Copy cmd error

From: <qinghuamail-postgresqlfans(at)yahoo(dot)com>
To: postgresql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Copy cmd error
Date: 2007-08-27 08:18:35
Message-ID: 972942.48089.qm@web58108.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!


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

Responses

pgsql-admin by date

Next:From: Johann SpiesDate: 2007-08-27 09:14:03
Subject: Re: PostgreSQL and virtualization
Previous:From: feng xinguoDate: 2007-08-27 08:17:07
Subject: use copy command!

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