Thread: pg_relcheck

pg_relcheck

From
"Christopher Kings-Lynne"
Date:
In terms of making constraints more declarative, I think it would be neat to
add an extra field to pg_relcheck that is a foreign key (or null) into the
pg_attribute table.

That way, it would be possible to recover column CHECK constraints.  If the
field is NULL, you'd assume it was a table CHECK constraint...

Theoretically, it would mean that less information is 'lost' after the table
creation.

Chris