How to get single table data from backup

Поиск
Список
Период
Сортировка

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.

В списке pgsql-general по дате отправления: