Parallel Safety
  • References/Database/PostgreSQL/Parallel Query

The planner classifies operations involved in a query as either parallel safe, parallel restricted, or parallel

2025-01-10 15:47:30
Catalogs: System Views
  • References/Database/PostgreSQL/Internals: Catalogs

In addition to the system catalogs, PostgreSQL provides a number of built-in views. Some system views provide convenient access to some commonly

2025-01-10 15:47:30
Catalogs: pg_amop
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_amop stores information about operators associated with access method operator families. There is one row for each operator that

2025-01-10 15:47:30
Catalogs: pg_pltemplate
  • References/Database/PostgreSQL/Internals: Catalogs

The catalog pg_pltemplate stores "template" information for procedural languages. A template for a language allows

2025-01-10 15:47:30
5.
  • References/Database/PostgreSQL/Tutorial/Advanced Features

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

2025-01-10 15:47:30
CREATE RULE
  • References/Database/PostgreSQL/Commands

NameCREATE RULE -- define a new rewrite rule Synopsis

2025-01-10 15:47:30
ALTER SCHEMA
  • References/Database/PostgreSQL/Commands

NameALTER SCHEMA -- change the definition of a schema Synopsis

2025-01-10 15:47:30
tablefunc
  • References/Database/PostgreSQL/Appendixes/Additional Supplied Modules

The tablefunc module includes various functions that return tables (that is, multiple rows). These functions are useful both in their own right

2025-01-10 15:47:30
SELECT INTO
  • References/Database/PostgreSQL/Commands

NameSELECT INTO -- define a new table from the results of a query Synopsis

2025-01-10 15:47:30
DROP OWNED
  • References/Database/PostgreSQL/Commands

NameDROP OWNED -- remove database objects owned by a database role Synopsis

2025-01-10 15:47:30