Re: pgdump with batch insert

From: jaime soler <jaime(dot)soler(at)gmail(dot)com>
To: Ankur Kaushik <ankurkaushik(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pgdump with batch insert
Date: 2015-04-22 15:35:24
Message-ID: 1429716924.19045.19.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

El mié, 08-04-2015 a las 17:32 +0530, Ankur Kaushik escribió:
> Hi ,
>
>
>
>
> Is there possibility in pgdump to get insert statement in batch insert
> into tablename value(),(),(),;

No, pg_dump doesn't generate insert statements of multiple values, just
one value per insert with --inserts

>
>
> as well as We can use replace keyword or insert ignore .

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message danny 2015-04-22 22:57:22 server doesn't listen postgresql 9.1 after service change
Previous Message Albe Laurenz 2015-04-21 08:32:07 Re: 8.4 to 9.4 migration - recommended practices