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.
