Tom Lane schrieb am 09.08.2022 um 15:27: > 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". Ah, thanks. I wasn't aware that -v would include dependencies.
