Re: How to get single table data from backup

Andrus <kobruleht2@hot.ee>

From: Andrus <kobruleht2@hot.ee>
To: Christoph Moench-Tegeder <cmt@burggraben.net>
Cc: pgsql-general <pgsql-general@postgresql.org>
Date: 2025-12-19T21:08:11Z
Lists: pgsql-general
Hi!

Geat answer since doesnt require manual sql editing. It worked.

Thank you.

Andrus.

19.12.2025 19:05 Christoph Moench-Tegeder kirjutas:
> ## Andrus (kobruleht2@hot.ee):
>
>> This fails since tabletorecover contains lot foreign key references.
> Check pg_restore options "--section=pre-data" and "--section=data" -
> pre-data is the schema without indexes, contraints, etc. (those
> would be in section post-data).
>
> Regards,
> Christoph
>