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

19.1.1. Parameter Names and Values All parameter names are case-insensitive. Every parameter takes a value of one of five types:

NameDROP MATERIALIZED VIEW -- remove a materialized view Synopsis

It is frequently convenient to group users together to ease management of privileges: that way, privileges can be granted to, or revoked from, a group as a whole. In

This module implements a data type seg for representing line segments, or floating point intervals. seg can represent uncertainty

NameBEGIN -- start a transaction block Synopsis

In addition to the postgresql.conf file already mentioned, PostgreSQL uses two other manually-edited configuration

The catalog pg_inherits records information about table inheritance hierarchies. There is one entry for each direct child table in the database

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 pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser