Re: pg_dump and insert multi-rows option - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_dump and insert multi-rows option
Date
Msg-id 8832.1188934808@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_dump and insert multi-rows option  (David Fetter <david@fetter.org>)
Responses Re: pg_dump and insert multi-rows option
Re: pg_dump and insert multi-rows option
List pgsql-hackers
David Fetter <david@fetter.org> writes:
> On Tue, Sep 04, 2007 at 01:22:01PM -0400, Tom Lane wrote:
>> ... The only reason I can see to
>> use these options today is if you want to try to port the dump to
>> some other database ... and in that case you probably shouldn't
>> assume multi-insert will work anyway.

> I'm pretty sure it does in the current versions of most other DBMSs.

Up to a point, perhaps.  Do you want to make assumptions about what
the maximum acceptable command length will be for other DBMSes?
It'd be hard enough being sure what to use for Postgres.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: pg_regress config
Next
From: Richard Huxton
Date:
Subject: Re: Has anyone tried out the PL/pgSQL debugger?