> This is precisely what I am looking for.
> Who wants to type in a huge list of tables?
> Not me. Also I'm not qualified to make
> these changes myself.
Apart from the referential inegrity problem, you can get the table
names with
SELECT relname FROM pg_class WHERE relname NOT LIKE 'pg
> Neil Conway <[EMAIL PROTECTED]> 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 restor
