Query goal: | Find user-defined rules for rewriting data manipulation language statements. Rules should be used only for the tasks that cannot be achieved in a declarative manner, i.e., for example, by declaring a constraint. |
Notes about the query: | Rules are specific to PostgreSQL and thus it is not possible to get information about these from the INFORMATION_SCHEMA views. The query does not find SELECT rules that are created automatically by the system to support views. |
Query type: | General (Overview of some aspect of the database.) |
Query license: | MIT License |
Data source: | system catalog only |
SQL query: | Click on query to copy it
SELECT r.schemaname AS rule_schema, r.tablename AS host_table, r.rulename AS rule_name, r.definition AS rule_definition FROM pg_catalog.pg_rules r, pg_catalog.pg_namespace n, pg_catalog.pg_authid u WHERE r.schemaname = n.nspname AND n.nspowner = u.oid AND (n.nspname = 'public' OR u.rolname <> 'postgres') ORDER BY schemaname, tablename, rulename; |
Collection name | Collection description |
---|---|
Find problems by overview | Queries that results point to different aspects of database that might have problems. A human reviewer has to decide based on the results as to whether there are problems or not . |
Category name | Category description |
---|---|
Triggers and rules | Queries of this category provide information about triggers and rules in a database. |