The view pg_matviews provides access to useful information about each materialized view in the database.

The catalog pg_statistic stores statistical data about the contents of the database. Entries are created by

The catalog pg_constraint stores check, primary key, unique, foreign key, and exclusion constraints on tables. (Column constraints are not treated

The view pg_rules provides access to useful information about query rewrite rules. Table

The catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view

The pg_cursors view lists the cursors that are currently available. Cursors can be defined in several ways:

The catalog pg_tablespace stores information about the available tablespaces. Tables can be placed in particular tablespaces to aid administration

The catalog pg_policy stores row level security policies for tables. A policy includes the kind of command that it applies to (possibly all

The catalog pg_attrdef stores column default values. The main information about columns is stored in pg_attribute

The catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the