To: pgsql-admin <pgsql-admin@postgresql.org>
From: Thomas Kellerer <shammat@gmx.net>
Subject: How to fully restore a single table from a custom dump?
Message-ID: <e434fe3f-0159-2223-8670-411d5c21c5bd@gmx.net>
Date: Tue, 9 Aug 2022 14:06:03 +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
Content-Type: text/plain; charset=utf-8
Content-Language: de-DE
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/e434fe3f-0159-2223-8670-411d5c21c5bd%40gmx.net>
Precedence: bulk

Hello,

I just realized that using

   pg_restore -t some_table ... some_dump_file

doesn't restore things like identity attributes
or indexes on the specified table.

The dump contains much more than just that table, so simply
using pg_restore without -t is not an option.

While I could extract the indexes manually using some clever regex
on the index names, I don't see a way to make sure that identity
definitions (or sequence values) are restored properly for the selected ta=
ble.

Any ideas, how I can _fully_ restore a single table from a custom dump?

Thomas