The planner classifies operations involved in a query as either parallel safe, parallel restricted, or parallel
In addition to the system catalogs, PostgreSQL provides a number of built-in views. Some system views provide convenient access to some commonly
The catalog pg_amop stores information about operators associated with access method operator families. There is one row for each operator that
The catalog pg_pltemplate stores "template" information for procedural languages. A template for a language allows
A window function performs a calculation across a set of table rows that are somehow related to the current row. This is comparable to the type of
NameCREATE RULE -- define a new rewrite rule Synopsis
NameALTER SCHEMA -- change the definition of a schema Synopsis
The tablefunc module includes various functions that return tables (that is, multiple rows). These functions are useful both in their own right
NameSELECT INTO -- define a new table from the results of a query Synopsis
NameDROP OWNED -- remove database objects owned by a database role Synopsis
Page 17 of 60