PostgreSQL Query Catalog

Find all non-foreign key columns of base tables. Make sure that no foreign key constraint is missing.

Find all non-identifying relationships where the foreign key (a set of columns) is a subset of a uniqueness constraint (primary key, unique, or exclude constraint).

Find all non-identifying relationships where the foreign key (a set of columns) is not a subset of any uniqueness constraint (primary key, unique, or exclude constraint).

Find all primary key and unique constraints of base tables that involve at least one column with personal names. Personal names are not unique and these cannot be (usually) used to guarantee uniqueness. Either one has declared a superkey instead of candidate key (i.e., the key contains a column that is not needed for uniqueness) or the key columns have been found incorrectly.

Find all routines that belong to an extension.

Find all security policies.

Find all sequence generators.

Find all tables that rows have been physically sorted based on an index.

Find all tables where default value is NULL. NULL is the marker that denotes missing value. Implicitly all columns that do not have a default value have the default NULL. There is no need to specify such default value.

Find all the base table columns that have the type time without time zone or time with time zone. Return the data only if there is at least one column with the type time without time zone and one column with the type time with time zone.

Find all the base table columns that have the type timestamp without time zone or timestamp with time zone. Return the data only if there is at least one column with the type timestamp without time zone and one column with the type timestamp with time zone.

Find all the base tables that serve as supertables in the inheritance hierarchies

Find all the comments that have been added with a COMMENT statement to schemas, sequences, types, domains, and event triggers.

Find all the default values of base table, view, and foreign table columns.

Find all the default values of base table, view, and foreign table columns that are expressions invoking a function that returns a timestamp. Do it only if there are different expressions, i.e., there could be possible inconsistencies.

Find all the schemas in the database that are not used for the system purposes.

Find all UPDATE triggers. Make sure that they specify a correct set of columns in which data modification will fire the trigger.

Find all user mappings for foreign servers and tables

Find a numerical measure that describes the extent of the database public interface (virtual data layer) through which users access the database.

Find a routine that's only task is to invoke another routine. If a routine performs only one action, delegating work to another routine, why does it exist at all?