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 catalog pg_db_role_setting records the default values that have been set for run-time configuration variables, for each role and database
Page 9 of 9