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/

Responses

• Re: pg_restore options issues at 2001-01-07 00:48:05 from Philip Warner

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2001-01-06 21:07:33
	Subject: Re: global/pg_database ?
Previous:	From: Tom Lane	Date: 2001-01-06 20:41:59
	Subject: Re: global/pg_database ?