How to get single table data from backup
| От | Andrus |
|---|---|
| Тема | How to get single table data from backup |
| Дата | |
| Msg-id | ff66d3ac-2e78-41ee-a511-7f934cb388ac@hot.ee обсуждение исходный текст |
| Ответы |
Re: How to get single table data from backup
Re: How to get single table data from backup Re: How to get single table data from backup |
| Список | 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.
В списке pgsql-general по дате отправления: