Message-ID: <0102019b37627d9c-03ffe58c-44b4-4245-8cde-fb8f84b97509-000000@eu-west-1.amazonses.com>
Date: Fri, 19 Dec 2025 16:12:40 +0000
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: How to get single table data from backup
To: Andrus <kobruleht2@hot.ee>, pgsql-general <pgsql-general@postgresql.org>
References: <ff66d3ac-2e78-41ee-a511-7f934cb388ac@hot.ee>
Content-Language: en-GB
From: Ray O'Donnell <ray@rodonnell.ie>
In-Reply-To: <ff66d3ac-2e78-41ee-a511-7f934cb388ac@hot.ee>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Feedback-ID: ::1.eu-west-1.Bw1eu/7Uepg3xcsiFBL71JJRCh2A2yTFrgBhhiulXmU=:AmazonSES
Archived-At: <https://www.postgresql.org/message-id/0102019b37627d9c-03ffe58c-44b4-4245-8cde-fb8f84b97509-000000%40eu-west-1.amazonses.com>
Precedence: bulk

On 19/12/2025 12:41, Andrus wrote:

> Hi!
>
> Large database backup is created using
>
> pg_dump -b -f backup.backup -F c
>
> How to restore single table in schema firma2 from it in Windows?
>
> Created database recovery and tried
>
> pg_restore --schema-only --n firma2 -d recovery backup.backup
> pg_restore -n firma2 -t tabletorecover -d recovery backup.backup
>
> This fails since tabletorecover contains lot foreign key references. 
> Foreign keys refer to other tables which have foreign keys to another 
> tables etc. making huge graph. All tables contain also data.
>
I haven't tried it, but - off the top of my head - how about:

(i) Create the table separately by hand, without the FK references.

(ii) Do a data-only restore, using the -a and -t options to pg_restore


Ray.


> I need to get table data only. Using PostgresSql 17 in windows.
>
> Andrus.
>
>
-- 
Ray O'Donnell // Galway // Ireland
ray@rodonnell.ie