Thread: how to dump all tables with pg_dump ?

Hi there,

I'm confused with pg_dump -t '*', it doesn't works as expected
from pg_dump --help:
 -t, --table=TABLE        dump this table only (* for all)

I tried any combinations  but never succeeded.
Regards,    Oleg
_____________________________________________________________
Oleg Bartunov, sci.researcher, hostmaster of AstroNet,
Sternberg Astronomical Institute, Moscow University (Russia)
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(095)939-16-83, +007(095)939-23-83

Oleg Bartunov <oleg@sai.msu.su> writes:
> I'm confused with pg_dump -t '*', it doesn't works as expected
> from pg_dump --help:

>   -t, --table=TABLE        dump this table only (* for all)

The help is mistaken --- that is not a working feature.  Leave out the
-t if you want all tables.
        regards, tom lane