The catalog pg_language registers languages in which you can write functions or stored procedures. See

The catalog pg_shdepend records the dependency relationships between database objects and shared objects, such as roles. This information allows

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

The catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database

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 view pg_file_settings provides a summary of the contents of the server's configuration file(s). A row appears in this view for each

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

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

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 catalog pg_attribute stores information about table columns. There will be exactly one pg_attribute row