The help text for the pg_restore --clean option in the documentation is IMHO more precise than the
text that the pg_restore binary gives:
documentation:-c--clean Clean (drop) database objects before recreating them.
pg_restore binary: -c, --clean clean (drop) schema prior to create
So I think it would be an improvement to channge the pg_restore --help text:
*** src/bin/pg_dump/pg_restore.c.orig 2008-12-27 01:16:23.000000000 +0100
--- src/bin/pg_dump/pg_restore.c 2008-12-27 01:29:53.000000000 +0100
***************
*** 385,391 ****
printf(_("\nOptions controlling the restore:\n")); printf(_(" -a, --data-only restore only the
data,no schema\n"));
! printf(_(" -c, --clean clean (drop) schema prior to create\n")); printf(_(" -C, --create
create the target database\n")); printf(_(" -I, --index=NAME restore named index\n"));
printf(_(" -L, --use-list=FILENAME use specified table of contents for ordering\n"
--- 385,391 ----
printf(_("\nOptions controlling the restore:\n")); printf(_(" -a, --data-only restore only the
data,no schema\n"));
! printf(_(" -c, --clean clean (drop) database objects prior to creating
them\n")); printf(_(" -C, --create create the target database\n")); printf(_(" -I,
--index=NAME restore named index\n")); printf(_(" -L, --use-list=FILENAME use specified table of
contentsfor ordering\n"
thanks,
Erik Rijkers