PG_CLASS v16
The PG_CLASS
view provides information about tables and other objects that have columns or are similar to a table in other ways. This information includes indexes, sequences, views, and other objects. In the context of this table, objects refers to relations.
In addition to the information in the PostgreSQL pg_class description, EDB Postgres Advanced Server provides the following information.
Name | Type | Description |
---|---|---|
relbackingtable | "char" | Identifies whether a table is backing relation for any other object. The default value is d for a normal object and q for queue tables. The relbackingtable is stored as q for all the backing objects of QUEUE TABLE (backing table, index, toast table, and so forth). |
relhasredactionpolicy | Boolean | Specifies whether object has a redaction policy. |
relpartname | text | Partition name. |