PostgreSQL Query Catalog

Project on GitHub
Filter Queries

Found 1031 queries.

  • All the queries about database objects contain a subcondition to exclude from the result information about the system catalog.
  • Although the statements use SQL constructs (common table expressions; NOT in subqueries) that could cause performance problems in case of large datasets it shouldn't be a problem in case of relatively small amount of data, which is in the system catalog of a database.
  • Statistics about the catalog content and project home in GitHub that has additional information.

# Name Goal ▲ Type Data source Last update License
81 All exclude constraints Find all exclude constraints. General system catalog base tables only 2025-11-07 10:11 MIT License View
82 All foreign tables Find all foreign tables. General INFORMATION_SCHEMA only 2025-11-07 10:11 MIT License View
83 All table functions Find all functions that return a set of rows. General INFORMATION_SCHEMA+system catalog base tables 2025-11-07 10:11 MIT License View
84 Find all non-foreign key columns of base tables Find all non-foreign key columns of base tables. Make sure that no foreign key constraint is missing. General INFORMATION_SCHEMA+system catalog base tables 2025-11-07 10:11 MIT License View
85 All identifying relationships 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). General system catalog base tables only 2025-11-07 10:11 MIT License View
86 All non-identifying relationships 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). General system catalog base tables only 2025-11-07 10:11 MIT License View
87 Personal names are unique 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. Problem detection system catalog base tables only 2025-11-07 10:11 MIT License View
88 Extension routines Find all routines that belong to an extension. General system catalog base tables only 2025-11-07 10:11 MIT License View
89 All security policies Find all security policies. General system catalog base tables only 2025-11-07 10:11 MIT License View
90 All sequence generators Find all sequence generators. General INFORMATION_SCHEMA+system catalog base tables 2025-11-07 10:11 MIT License View
91 All clustered indexes Find all tables that rows have been physically sorted based on an index. General system catalog base tables only 2025-11-07 10:11 MIT License View
92 Default is NULL 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. Problem detection INFORMATION_SCHEMA only 2025-11-07 10:11 MIT License View
93 Should the time zone be recorded in case of time or not? 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. Problem detection INFORMATION_SCHEMA only 2025-11-07 10:11 MIT License View
94 Should the time zone be recorded in case of timestamp or not? 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. Problem detection INFORMATION_SCHEMA only 2025-11-07 10:11 MIT License View
95 All supertables Find all the base tables that serve as supertables in the inheritance hierarchies Sofware measure system catalog base tables only 2025-11-07 10:11 MIT License View
96 Comments of schemas, sequences, types, domains, domain constraints, and event triggers Find all the comments that have been added with a COMMENT statement to schemas, sequences, types, domains, and event triggers. General system catalog base tables only 2025-11-07 10:11 MIT License View
97 All column DEFAULT values Find all the default values of base table, view, and foreign table columns. General INFORMATION_SCHEMA only 2025-11-07 10:11 MIT License View
98 Different ways how to find default timestamp values 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. Problem detection INFORMATION_SCHEMA only 2025-11-07 10:11 MIT License View
99 All user schemas Find all the schemas in the database that are not used for the system purposes. General INFORMATION_SCHEMA only 2025-11-07 10:11 MIT License View
100 UPDATE triggers Find all UPDATE triggers. Make sure that they specify a correct set of columns in which data modification will fire the trigger. General INFORMATION_SCHEMA only 2025-11-07 10:11 MIT License View