On 12/19/25 04: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 need to get table data only. Using PostgresSql 17 in windows.
1) Does the table name tabletorecover occur in more then one SCHEMA?
2) Do you want only the table data for tabletorecover?
Assuming 1 is one SCHEMA only and 2 is tabletorecover data only then
maybe something like:
1) pg_restore --schema-only --table=tabletorecover -d recovery backup.backup
2) In psql ALTER TABLE tabletorecover DROP CONSTRAINT the FK references
in tabletorecover.
3) pg_restore --data-only --table=tabletorecover -d recovery backup.backup
Andrus.
--
Adrian Klaver
[email protected]
