From: Tom Lane <tgl@sss.pgh.pa.us>
To: Thomas Kellerer <shammat@gmx.net>
cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: How to fully restore a single table from a custom dump?
In-reply-to: <e434fe3f-0159-2223-8670-411d5c21c5bd@gmx.net>
References: <e434fe3f-0159-2223-8670-411d5c21c5bd@gmx.net>
Comments: In-reply-to Thomas Kellerer <shammat@gmx.net>
	message dated "Tue, 09 Aug 2022 14:06:03 +0200"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <819153.1660051665.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Tue, 09 Aug 2022 09:27:45 -0400
Message-ID: <819154.1660051665@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/819154.1660051665%40sss.pgh.pa.us>
Precedence: bulk

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 po=
stgres
;       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