PostgreSQL Query Catalog

Make sure that you do not drop INFORMATION_SCHEMA schema. In this case most of the design checking queries will not work. This schema automatically exists in all databases.

For the sake of making code better understandable follow naming conventions.

Try to use as much the possibilities of the DBMS as possible. On the other hand, do not install extensions that are not needed in order not to overcomplicate the database.

You must give rights to use routines to the users/roles that correspond to applications.

You must give privileges to use views to the users/roles that correspond to applications

PostgreSQL regular expressions do not have character classes word and letter.

Find regular expression patterns that use (?i) modifier in any other place than at the beginning of the pattern or (?-i) in any place of the pattern. Such use of the modifiers is not supported by PostgreSQL.

Find user-defined routines that contain an invocation of a system-defined function without providing any argument. The query considers all aggregate functions as well as some popular scalar functions.

Find derived tables that subqueries invoke a PL/pgSQL function. Avoid context switch that is caused by the invocation of PL/pgSQL functions from the subqueries of derived tables.

Use a right predicate in trigger condition in order to ensure that the trigger executes always when it has to but not more often. IS DISTINCT FROM treats NULL as if it was a known value, rather than unknown. It would be relevant if a column that is referenced in the action condition is optional, i.e., permits NULLs.

Avoid using IS NOT DISTINCT FROM because it makes the query planner to avoid using an index.

Avoid using IS NOT DISTINCT FROM because it makes the query planner to avoid using an index.

Find CHECK constraints that refer only to mandatory columns but the Boolean expression has IS NULL condition.

"In general, most applications should prefer to store JSON data as jsonb, unless there are quite specialized needs, such as legacy assumptions about ordering of object keys." (https://www.postgresql.org/docs/current/datatype-json.html)

You should not give wrong information to the database management system.

Find non-primary key and non-unique base table foreign key columns that name refers to the possibility that these are used to register references to a state classifier. The column must belong to a foreign key and does not have a default value.

Find expressions that use LIKE predicate for precise comparison.

Find expressions that use LIKE (including ILIKE) predicate with a regular expression patterns. In a LIKE pattern one can use only _ and % metasymbols to construct a pattern.

Find expressions that use LIKE predicate witout a pattern that contains at least one % or _ sign.

The schema size is the sum of the sizes of all tables in the schema.