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

From Bruce Momjian
Subject Re: pg_dump and insert multi-rows option
Date
Msg-id 200709042126.l84LQxv24675@momjian.us
Whole thread Raw
In response to Re: pg_dump and insert multi-rows option  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> 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.

Wow, first mention of "Postgres" in the wild.  :-)  LOL

--  Bruce Momjian  <bruce@momjian.us>          http://momjian.us EnterpriseDB
http://www.enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Has anyone tried out the PL/pgSQL debugger?
Next
From: John DeSoi
Date:
Subject: Re: Has anyone tried out the PL/pgSQL debugger?