Thomas Kellerer <shammat@xxxxxxx> writes: > Any ideas, how I can _fully_ restore a single table from a custom dump? "pg_restore -l -v" will give you a table-of-contents with dependencies, like this: 8155; 0 40431 MATERIALIZED VIEW DATA public analytics_materialized_view postgres ; depends on: 960 8161 This is object number 8155 and it depends on objects 960 and 8161. Find the table you want, then look for things with dependencies on it (some of them may not be things you want to restore). Edit away all the lines for things you don't want, then feed the reduced list to "pg_restore -L". regards, tom lane
