Periodically irregular technology and culture blogging since 2002. By David E. Wheeler.| ❖ Just a Theory
PREPARE PREPARE — prepare a statement for execution Synopsis PREPARE name [ ( data_type [, ...] ) ] AS statement …| PostgreSQL Documentation
9.27. System Information Functions and Operators # 9.27.1. Session Information Functions 9.27.2. Access Privilege Inquiry Functions 9.27.3. Schema Visibility Inquiry Functions …| PostgreSQL Documentation
65.2. TOAST # 65.2.1. Out-of-Line, On-Disk TOAST Storage 65.2.2. Out-of-Line, In-Memory TOAST Storage This section provides an overview of TOAST (The …| PostgreSQL Documentation
36.7. Function Volatility Categories # Every function has a volatility classification, with the possibilities being VOLATILE, STABLE, or IMMUTABLE. VOLATILE is …| PostgreSQL Documentation
CREATE MATERIALIZED VIEW CREATE MATERIALIZED VIEW — define a new materialized view Synopsis CREATE MATERIALIZED VIEW [ IF NOT EXISTS …| PostgreSQL Documentation
VACUUM VACUUM — garbage-collect and optionally analyze a database Synopsis VACUUM [ ( option [, ...] ) ] [ table_and_columns …| PostgreSQL Documentation
ALTER TABLE ALTER TABLE — change the definition of a table Synopsis ALTER TABLE [ IF EXISTS ] [ ONLY …| PostgreSQL Documentation
5.9. Row Security Policies # In addition to the SQL-standard privilege system available through GRANT, tables can have row security policies …| PostgreSQL Documentation
ANALYZE ANALYZE — collect statistics about a database Synopsis ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, …| PostgreSQL Documentation