how to dump all tables with pg_dump ?

Started by Oleg Bartunovover 22 years ago2 messageshackers
Jump to latest
#1Oleg Bartunov
oleg@sai.msu.su

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Oleg Bartunov (#1)
Re: how to dump all tables with pg_dump ?

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