Neil Conway <nconway(at)klamath(dot)dyndns(dot)org> writes:
>> It's just
>> for i in t1 t2 t3; do pg_dump -t$i mydb > $i.tbl; done
> Although with a strategy like this, they're no guarantee that the
> snapshot you get will be consistent. And if you're using refential
> integrity it might not even restore properly.
Good point. So who wants to tweak pg_dump to accept multiple -t
switches? Seems like
pg_dump -t foo -t bar -t baz dbname
is a reasonably non-ambiguous syntax.
regards, tom lane