Re: pg_dump and insert multi-rows option

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: Cédric Villemain <cedric(dot)villemain(at)dalibo(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_dump and insert multi-rows option
Date: 2007-09-04 19:40:08
Message-ID: 8832.1188934808@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

David Fetter <david(at)fetter(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Richard Huxton 2007-09-04 19:45:42 Re: Has anyone tried out the PL/pgSQL debugger?
Previous Message Magnus Hagander 2007-09-04 18:46:13 Re: pg_regress config