• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_RULES

PG_RULES

PG_RULES provides access to useful information about query rewrite rules.

Table 1 PG_RULES columns

Name

Type

Description

schemaname

name

Name of schema containing table

tablename

name

Name of table the rule is for

rulename

name

Name of rule

definition

text

Rule definition (a reconstructed creation command)