Re: How to get single table data from backup - Mailing list pgsql-general

Hi!

Geat answer since doesnt require manual sql editing. It worked.

Thank you.

Andrus.

## Andrus (kobruleht2@hot.ee):

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