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 catalog pg_inherits records information about table inheritance hierarchies. There is one entry for each direct child table in the database

The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning

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_seclabel stores security labels on database objects. Security labels can be manipulated with the

The catalog pg_attribute stores information about table columns. There will be exactly one pg_attribute row

The catalog pg_opfamily defines operator families. Each operator family is a collection of operators and associated support routines that implement

The view pg_user provides access to information about database users. This is simply a publicly readable view of