On 7/12/06 3:32 AM, "Rafal Pietrak" <rafal@xxxxxxxxxxxxxxxxxx> wrote: > On Tue, 2006-07-11 at 15:24 -0500, Ron Johnson wrote: >> Joshua D. Drake wrote: >>> It is also something that users are clammoring for (and my customers). To >>> the point that I have customers using unions to emulate the behavior. Why? >>> Because it is really, really fast. >> >> When inserting multiple rows in the same INSERT statement, how do >> you tell which row fails on a constraint or datatype-mismatch violation? > > BTW. COPY from psql client is quite trivial (we learn that from > pg_dump), but can someone hint on how to use it from perl scrypt? With > "use DBI" module? > See the DBD::Pg documentation, under "copy support". Sean
