Sample Header Ad - 728x90

pg_dump - table dependencies when using --table

1 vote
2 answers
609 views
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