On 17 December 2011 00:17, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
> Add --section option to pg_dump and pg_restore.
>
> Valid values are --pre-data, data and post-data. The option can be
> given more than once. --schema-only is equivalent to
> --section=pre-data --section=post-data. --data-only is equivalent
> to --section=data.
"Post-data items consist of definitions of indexes, triggers, rules
and constraints other than check constraints."
What about NOT VALID check constraints? Those are required to be post-data.
--
Thom