PostgreSQL Domain Integrity In Depth

SQL has many features to protect data, and domain integrity constraints are one of the most fundamental. Put simply, they restrict columns to sensible values and prevent data input errors and other problems. On the surface domain integrity is simpler than other techniques such as referential integrity. Domains usually don’t need to cross-reference values in multiple tables. However in this article we’ll see some advanced tricks to keep data squeaky clean. This guide combines pretty much all mate...

Submit