Hi,
man pg_restore:

-a
Restore only the data, not the schema (data definitions).
-c
Clean (drop) database objects before recreating them.

If -a is given, -c is ignored. But I think it would be good, it will
result to a "DELETE FROM mytable" command before the restore.

Do you think it is a useful feature request? If yes, where should I send
it to?

Thomas

--
Thomas Guettler, http://www.thomas-guettler.de/
E-Mail: guettli (*) thomas-guettler + de

Thomas Guettler <hv (AT) tbz-pariv (DOT) de> wrote:
Maybe the documentation should be modified to prevent that kind of
misinterpretation:

It would not result in a "DELETE FROM mytable", but in a
"DROP TABLE mytable", which would make subsequent INSERTs fail.

I think it is called "clean" in the man page to explain why the flag
"-c" was chosen.

Yours,
Laurenz Albe

Thomas Guettler <hv (AT) tbz-pariv (DOT) de> wrote:
Maybe the documentation should be modified to prevent that kind of
misinterpretation:

It would not result in a "DELETE FROM mytable", but in a
"DROP TABLE mytable", which would make subsequent INSERTs fail.

I think it is called "clean" in the man page to explain why the flag
"-c" was chosen.

Yours,
Laurenz Albe

Thomas Guettler <hv (AT) tbz-pariv (DOT) de> wrote:
Maybe the documentation should be modified to prevent that kind of
misinterpretation:

It would not result in a "DELETE FROM mytable", but in a
"DROP TABLE mytable", which would make subsequent INSERTs fail.

I think it is called "clean" in the man page to explain why the flag
"-c" was chosen.

Yours,
Laurenz Albe

Thomas Guettler <hv (AT) tbz-pariv (DOT) de> wrote:
Maybe the documentation should be modified to prevent that kind of
misinterpretation:

It would not result in a "DELETE FROM mytable", but in a
"DROP TABLE mytable", which would make subsequent INSERTs fail.

I think it is called "clean" in the man page to explain why the flag
"-c" was chosen.

Yours,
Laurenz Albe

Thomas Guettler <hv (AT) tbz-pariv (DOT) de> wrote:
Maybe the documentation should be modified to prevent that kind of
misinterpretation:

It would not result in a "DELETE FROM mytable", but in a
"DROP TABLE mytable", which would make subsequent INSERTs fail.

I think it is called "clean" in the man page to explain why the flag
"-c" was chosen.

Yours,
Laurenz Albe

Thomas Guettler <hv (AT) tbz-pariv (DOT) de> wrote:
Maybe the documentation should be modified to prevent that kind of
misinterpretation:

It would not result in a "DELETE FROM mytable", but in a
"DROP TABLE mytable", which would make subsequent INSERTs fail.

I think it is called "clean" in the man page to explain why the flag
"-c" was chosen.

Yours,
Laurenz Albe

Thomas Guettler <hv (AT) tbz-pariv (DOT) de> wrote:
Maybe the documentation should be modified to prevent that kind of
misinterpretation:

It would not result in a "DELETE FROM mytable", but in a
"DROP TABLE mytable", which would make subsequent INSERTs fail.

I think it is called "clean" in the man page to explain why the flag
"-c" was chosen.

Yours,
Laurenz Albe

Thomas Guettler <hv (AT) tbz-pariv (DOT) de> wrote:
Maybe the documentation should be modified to prevent that kind of
misinterpretation:

It would not result in a "DELETE FROM mytable", but in a
"DROP TABLE mytable", which would make subsequent INSERTs fail.

I think it is called "clean" in the man page to explain why the flag
"-c" was chosen.

Yours,
Laurenz Albe