Re: How to get single table data from backup

From: Andrus <kobruleht2(at)hot(dot)ee>
To: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get single table data from backup
Date: 2025-12-19 21:08:11
Message-ID: 5b7b0914-ae51-48cb-a6a8-db678f42ebd5@hot.ee
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
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(at)hot(dot)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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2025-12-19 21:21:11 Re: Fwd: PQexecPrepared() question
Previous Message Tom Lane 2025-12-19 19:18:15 Re: Fwd: PQexecPrepared() question