Refer back to the queries in Section 2.6. Suppose the combined listing

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

The idea behind this dump method is to generate a file with SQL commands that, when fed back to the server, will recreate the database in the same state as it was at the time

NameALTER DOMAIN -- change the definition of a domain Synopsis

NameREVOKE -- remove access privileges Synopsis

NameALTER SERVER -- change the definition of a foreign server Synopsis

NameCREATE SERVER -- define a new foreign server Synopsis

NameCREATE FOREIGN DATA WRAPPER -- define a new foreign-data wrapper Synopsis

The intagg module provides an integer aggregator and an enumerator. intagg is now obsolete, because there are built-in

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