The catalog pg_policy stores row level security policies for tables. A policy includes the kind of command that it applies to (possibly all
The catalog pg_attrdef stores column default values. The main information about columns is stored in pg_attribute
NameALTER TABLE -- change the definition of a table Synopsis
The catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the
For convenience there are also single letter command-line option switches available for some parameters. They are described in Table 19-2. Some of these options exist for historical
A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate
The catalog pg_amproc stores information about support procedures associated with access method operator families. There is one row for each
NameNOTIFY -- generate a notification Synopsis
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_views provides access to useful information about each view in the database.
Page 51 of 60