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

Tom Lane schrieb am 09.08.2022 um 15:27:
> Thomas Kellerer <shammat(at)gmx(dot)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".

Ah, thanks. I wasn't aware that -v would include dependencies.