Re: How to fully restore a single table from a custom dump?

Thomas Kellerer <shammat@gmx.net> 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