PostgreSQL: Documentation: 17: Appendix M. Glossary
Appendix M. Glossary This is a list of terms and their meaning in the context of PostgreSQL and relational database systems in …| PostgreSQL Documentation
Appendix M. Glossary This is a list of terms and their meaning in the context of PostgreSQL and relational database systems in …| PostgreSQL Documentation
19.5. Write Ahead Log # 19.5.1. Settings 19.5.2. Checkpoints 19.5.3. Archiving 19.5.4. Recovery 19.5.5. Archive Recovery 19.5.6. Recovery Target 19.5.7. WAL …| PostgreSQL Documentation
5.10. Schemas # 5.10.1. Creating a Schema 5.10.2. The Public Schema 5.10.3. The Schema Search Path 5.10.4. Schemas and Privileges 5.10.5. …| PostgreSQL Documentation
25.3. Continuous Archiving and Point-in-Time Recovery (PITR) # 25.3.1. Setting Up WAL Archiving 25.3.2. Making a Base Backup 25.3.3. Making an …| PostgreSQL Documentation
SAVEPOINT SAVEPOINT — define a new savepoint within the current transaction Synopsis SAVEPOINT savepoint_name Description SAVEPOINT establishes a new savepoint …| PostgreSQL Documentation
MERGE MERGE — conditionally insert, update, or delete rows of a table Synopsis [ WITH with_query [, ...] ] MERGE …| PostgreSQL Documentation
GRANT GRANT — define access privileges Synopsis GRANT { { SELECT | INSERT | UPDATE | DELETE | TRUNCATE | …| PostgreSQL Documentation
CREATE SERVER CREATE SERVER — define a new foreign server Synopsis CREATE SERVER [ IF NOT EXISTS ] server_name [ …| PostgreSQL Documentation
36.17. Packaging Related Objects into an Extension # 36.17.1. Extension Files 36.17.2. Extension Relocatability 36.17.3. Extension Configuration Tables 36.17.4. Extension Updates …| PostgreSQL Documentation
19.3. Connections and Authentication # 19.3.1. Connection Settings 19.3.2. TCP Settings 19.3.3. Authentication 19.3.4. SSL 19.3.1. Connection Settings # listen_addresses (string) # …| PostgreSQL Documentation
SELECT SELECT, TABLE, WITH — retrieve rows from a table or view Synopsis [ WITH [ RECURSIVE ] with_query [, …| PostgreSQL Documentation
19.8. Error Reporting and Logging # 19.8.1. Where to Log 19.8.2. When to Log 19.8.3. What to Log 19.8.4. Using CSV-Format …| PostgreSQL Documentation
pg_basebackup pg_basebackup — take a base backup of a PostgreSQL cluster Synopsis pg_basebackup [option...] Description pg_basebackup is used to take …| PostgreSQL Documentation
Chapter 61. Table Access Method Interface Definition This chapter explains the interface between the core PostgreSQL system and table access methods, which …| 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
CREATE TABLE CREATE TABLE — define a new table Synopsis CREATE [ [ GLOBAL | LOCAL ] { TEMPORARY | …| PostgreSQL Documentation
CREATE FOREIGN TABLE CREATE FOREIGN TABLE — define a new foreign table Synopsis CREATE FOREIGN TABLE [ IF NOT EXISTS …| PostgreSQL Documentation
13.2. Transaction Isolation # 13.2.1. Read Committed Isolation Level 13.2.2. Repeatable Read Isolation Level 13.2.3. Serializable Isolation Level The SQL standard …| PostgreSQL Documentation
INSERT INSERT — create new rows in a table Synopsis [ WITH [ RECURSIVE ] with_query [, ...] ] INSERT …| PostgreSQL Documentation
27.2. The Cumulative Statistics System # 27.2.1. Statistics Collection Configuration 27.2.2. Viewing Statistics 27.2.3. pg_stat_activity 27.2.4. pg_stat_replication 27.2.5. pg_stat_replication_slots 27.2.6. pg_stat_wal_receiver …| PostgreSQL Documentation
CREATE FUNCTION CREATE FUNCTION — define a new function Synopsis CREATE [ OR REPLACE ] FUNCTION name ( [ [ …| PostgreSQL Documentation
19.4. Resource Consumption # 19.4.1. Memory 19.4.2. Disk 19.4.3. Kernel Resource Usage 19.4.4. Cost-based Vacuum Delay 19.4.5. Background Writer 19.4.6. Asynchronous …| PostgreSQL Documentation
CREATE INDEX CREATE INDEX — define a new index Synopsis CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ …| PostgreSQL Documentation
CREATE VIEW CREATE VIEW — define a new view Synopsis CREATE [ OR REPLACE ] [ TEMP | TEMPORARY ] …| PostgreSQL Documentation
CREATE MATERIALIZED VIEW CREATE MATERIALIZED VIEW — define a new materialized view Synopsis CREATE MATERIALIZED VIEW [ IF NOT EXISTS …| PostgreSQL Documentation
24.1. Routine Vacuuming # 24.1.1. Vacuuming Basics 24.1.2. Recovering Disk Space 24.1.3. Updating Planner Statistics 24.1.4. Updating the Visibility Map 24.1.5. …| PostgreSQL Documentation
5.5. Constraints # 5.5.1. Check Constraints 5.5.2. Not-Null Constraints 5.5.3. Unique Constraints 5.5.4. Primary Keys 5.5.5. Foreign Keys 5.5.6. Exclusion Constraints …| PostgreSQL Documentation
ANALYZE ANALYZE — collect statistics about a database Synopsis ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, …| PostgreSQL Documentation
