The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser

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

The view pg_group exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before

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

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

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

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

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

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