Subject: Re: How to fully restore a single table from a custom dump?
Cc: pgsql-admin <pgsql-admin@postgresql.org>
References: <e434fe3f-0159-2223-8670-411d5c21c5bd@gmx.net>
 <819154.1660051665@sss.pgh.pa.us>
From: Thomas Kellerer <shammat@gmx.net>
Message-ID: <a4428a67-51c5-8e84-c0de-8c803ea02edf@gmx.net>
Date: Wed, 10 Aug 2022 07:14:06 +0200
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.23)
 Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.6.666
MIME-Version: 1.0
In-Reply-To: <819154.1660051665@sss.pgh.pa.us>
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/a4428a67-51c5-8e84-c0de-8c803ea02edf%40gmx.net>
Precedence: bulk

Tom Lane schrieb am 09.08.2022 um 15:27:
> 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".


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