Re: pgsql vs mysql - Mailing list pgsql-general

From Rafal Pietrak
Subject Re: pgsql vs mysql
Date
Msg-id 1152689561.6764.80.camel@model.home.waw.pl
Whole thread Raw
In response to Re: pgsql vs mysql  (Ron Johnson <ron.l.johnson@cox.net>)
Responses Re: pgsql vs mysql
List pgsql-general
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?


--
-R

pgsql-general by date:

Previous
From: Rafal Pietrak
Date:
Subject: using ROLE system
Next
From: Csaba Nagy
Date:
Subject: Re: pgsql vs mysql