The documentation says this when using
-t table
:
> Note When -t is specified, pg_dump makes no attempt to dump any other
> database objects that the selected table(s) might depend upon.
> Therefore, there is no guarantee that the results of a specific-table
> dump can be successfully restored by themselves into a clean database.
However, when the table has a sequence, and the owned by
for the sequence is set to the table, it is included in the dump.
Shouldn't it be excluded according to this part of the documentation? (If so, why are sequences exceptions?)
What kind of database objects are going to be excluded in -t table
mode then?
Asked by user
(113 rep)
Jan 25, 2020, 02:53 PM
Last activity: Jul 2, 2025, 01:18 PM
Last activity: Jul 2, 2025, 01:18 PM