The catalog pg_amproc stores information about support procedures associated with access method operator families. There is one row for each

The catalog pg_database stores information about the available databases. Databases are created with the

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

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

The catalog pg_extension stores information about the installed extensions. See Section 36.15 for details about extensions.

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_group exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before

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 catalog pg_attrdef stores column default values. The main information about columns is stored in pg_attribute