postgres dump with inserts but without copy actions

Question

I am trying to dump my database.

For reasons I can't go into detail here, I am unable to use the "Copy" function. This means that the insert statements have to be "pure" insert. However, I am not sure how to reflect this in my dump.

Currently, this is my dump command:

 pg_dump -U myUser --column-inserts --data-only  -h localhost my_db> backup

Can anyone tell me how i might get the insert statements without the Copy function?

Answer 1

The documentation of pg_dumps tells us this:

--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.