pg_restore has some options that are supposed to allow restoring some or
all indexes/tables/triggers/etc. For example
pg_restore --table
restores all tables and
pg_restore --table=my_table
restores only the named table. The equivalent short option is -t but it
does not allow restoring all tables, since it requires an argument. I
suggest that an argument of '*' also means to restore all tables.
Also, if you just call pg_restore without arguments it hangs waiting for
input from stdin. This is a bit confusing. I suggest that stdin is used
if and only if the file name argument is '-'.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/