PostgreSQL Query Catalog

Project on GitHub
Filter Queries

Found 997 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
1 Address field size is incorrect (too short or too long) Find base table columns that are meant for recording different types of addresses where the filed size does not take into account the possible maximum length. Problem detection INFORMATION_SCHEMA only 2023-11-09 12:55 MIT License View
2 A getter does not return a value Find user-defined SQL and PL/pgSQL routines that do not return a value although the name suggest that it should return a value (starts with "get"). Problem detection INFORMATION_SCHEMA+system catalog base tables 2023-01-06 14:24 MIT License View
3 A large number of triggers Show user-defined triggers if there are more than 9 different trigger routine bodies, i.e., different triggers on different tables that do the same thing count as one trigger. General INFORMATION_SCHEMA+system catalog base tables 2023-12-25 11:23 MIT License View
4 All CHECK constraints of domains that are not associated with any table Find all CHECK constraints (except NOT NULL) of domains that are not associated with any column. General INFORMATION_SCHEMA only 2020-11-06 14:51 MIT License View
5 All clustered indexes Find all tables that rows have been physically sorted based on an index. General system catalog base tables only 2022-10-31 10:17 MIT License View
6 All column DEFAULT values Find all the default values of base table, view, and foreign table columns. General INFORMATION_SCHEMA only 2022-10-31 10:18 MIT License View
7 All column dynamic DEFAULT values values that do not invoke a sequence Find all columns that have a dynamic default value, i.e., the value is returned by a function but the function is not for invoking a sequence. General INFORMATION_SCHEMA only 2021-11-15 15:57 MIT License View
8 All columns of a base table have a default value Find base tables where all the columns have a default value. Problem detection INFORMATION_SCHEMA only 2021-02-25 17:29 MIT License View
9 All column static DEFAULT values Find all columns that have a static default value, i.e., the value is not returned by a function. General INFORMATION_SCHEMA only 2021-11-15 15:57 MIT License View
10 All covering indexes Find all covering indexes, which include data from additional columns in leaf blocks. General INFORMATION_SCHEMA+system catalog base tables 2020-12-23 11:54 MIT License View
11 All database privileges Find the privileges to use the database. c - CONNECT; C - CREATE; T - TEMPORARY. General system catalog base tables only 2021-11-23 20:28 MIT License View
12 All declaratively partitioned tables Find partitioned tables that have been implemented by using the declarative approach. Declarative partitioning is implemented in PostgreSQL starting from PostgreSQL 10. General INFORMATION_SCHEMA+system catalog base tables 2020-11-06 15:13 MIT License View
13 All derived tables that use joining tables Find all derived tables that join two or more tables. General INFORMATION_SCHEMA+system catalog base tables 2024-10-05 18:34 MIT License View
14 All domain default values Find domains that specify a default values and columns that are defined based on the domain. Make sure that there are no unsuitable default values. General INFORMATION_SCHEMA only 2021-01-19 13:04 MIT License View
15 All domains Find all domains. General INFORMATION_SCHEMA only 2020-11-10 11:49 MIT License View
16 All enumerated types Find all enumerated types. General INFORMATION_SCHEMA+system catalog base tables 2022-10-31 10:19 MIT License View
17 All event triggers Find event triggers, which are not associated to a specific schema object. General system catalog base tables only 2020-12-24 14:54 MIT License View
18 All exclude constraints Find all exclude constraints. General system catalog base tables only 2021-12-16 11:21 MIT License View
19 All foreign key constraints Enforce referential integrity in database. Find all referential integrity (foreign key) constraints. General system catalog base tables only 2023-12-07 12:48 MIT License View
20 All foreign tables Find all foreign tables. General INFORMATION_SCHEMA only 2020-11-06 15:20 MIT License View