The view pg_settings provides access to run-time parameters of the server. It is essentially an alternative interface to the

The catalog pg_auth_members shows the membership relations between roles. Any non-circular set of relationships is allowed.

The view pg_seclabels provides information about security labels. It as an easier-to-query version of the

The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection

The catalog pg_range stores information about range types. This is in addition to the types' entries in

The catalog pg_description stores optional descriptions (comments) for each database object. Descriptions can be manipulated with the

The catalog pg_transform stores information about transforms, which are a mechanism to adapt data types to procedural languages. See

The pg_prepared_statements view displays all the prepared statements that are available in the current session. See

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

The view pg_tables provides access to useful information about each table in the database.