pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpgdump with batch insert
3+ messages / 3 participants
[nested] [flat]
* pgdump with batch insert
@ 2015-04-08 12:02 Ankur Kaushik <ankurkaushik@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Ankur Kaushik @ 2015-04-08 12:02 UTC (permalink / raw)
To: pgsql-admin
Hi ,
Is there possibility in pgdump to get insert statement in batch insert into
tablename value(),(),(),;
as well as We can use replace keyword or insert ignore .
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgdump with batch insert
@ 2015-04-08 12:31 Jan Lentfer <Jan.Lentfer@web.de>
parent: Ankur Kaushik <ankurkaushik@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Jan Lentfer @ 2015-04-08 12:31 UTC (permalink / raw)
To: pgsql-admin
Am 2015-04-08 14:02, schrieb Ankur Kaushik:
> Is there possibility in pgdump to get insert statement in batch
> insert
> into tablename value(),(),(),;
>
> as well as We can use replace keyword or insert ignore .
Have you read the documentation for pg_dump?
http://www.postgresql.org/docs/9.3/static/app-pgdump.html
--inserts
Dump data as INSERT commands (rather than COPY). This will make
restoration very slow; it is mainly useful for making dumps that can be
loaded into non-PostgreSQL databases. However, since this option
generates a separate command for each row, an error in reloading a row
causes only that row to be lost rather than the entire table contents.
Note that the restore might fail altogether if you have rearranged
column order. The --column-inserts option is safe against column order
changes, though even slower.
Regards
Jan
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pgdump with batch insert
@ 2015-04-22 15:35 jaime soler <jaime.soler@gmail.com>
parent: Ankur Kaushik <ankurkaushik@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: jaime soler @ 2015-04-22 15:35 UTC (permalink / raw)
To: Ankur Kaushik <ankurkaushik@gmail.com>; +Cc: 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 .
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2015-04-22 15:35 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2015-04-08 12:02 pgdump with batch insert Ankur Kaushik <ankurkaushik@gmail.com>
2015-04-08 12:31 ` Jan Lentfer <Jan.Lentfer@web.de>
2015-04-22 15:35 ` jaime soler <jaime.soler@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox