How to get single table data from backup
Andrus <kobruleht2@hot.ee>
From: Andrus <kobruleht2@hot.ee>
To: pgsql-general <pgsql-general@postgresql.org>
Date: 2025-12-19T12:41:37Z
Lists: pgsql-general
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 need to get table data only. Using PostgresSql 17 in windows. Andrus.