Re: How to get single table data from backup

## Andrus ([email protected]): > This fails since tabletorecover contains lot foreign key references. Check pg_restore options "--section=pre-data" and "--section=data" - pre-data is the schema without indexes, contraints, etc. (those would be in section post-data). Regards, Christoph -- Spare

Re: How to get single table data from backup

On 12/19/25 08:12, Adrian Klaver wrote: 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 re

Re: How to get single table data from backup

On 19/12/2025 12: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 fir

Re: How to get single table data from backup

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

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 bac