Tom Lane writes:
> I think it'd be a bit surprising if "pg_dump -t table" would dump
> sequences declared independently of the table. An example where you'd
> likely not be happy with that is if the same sequence is being used to
> feed multiple tables.
>
> I agree that dumping all such sequences will often be the desired
> behavior, but that doesn't leave me convinced that it's the right
> thing to do.
>
> Any comments out there?
The more general question is: Should 'pg_dump -t table' dump all objects
that "table" depends on? Keep in mind that this could mean you have to
dump the entire database (think foreign keys). In my mind, dumping an
arbitrary subset of dependencies is not a proper solution, though.
--
Peter Eisentraut peter_e@gmx.net