PostgreSQL 14.5 Documentation
SET ROLE ................................................................................................... 2022
SET SESSION AUTHORIZATION .................................................................. 2024
SET TRANSACTION .................................................................................... 2026
SHOW ......................................................................................................... 2029
START TRANSACTION ................................................................................ 2031
TRUNCATE ................................................................................................. 2032
UNLISTEN ................................................................................................... 2035
UPDATE ...................................................................................................... 2037
VACUUM .................................................................................................... 2042
VALUES ...................................................................................................... 2047
II. PostgreSQL Client Applications ........................................................................... 2050
clusterdb ....................................................................................................... 2051
createdb ........................................................................................................ 2054
createuser ..................................................................................................... 2058
dropdb ......................................................................................................... 2063
dropuser ....................................................................................................... 2066
ecpg ............................................................................................................. 2069
pg_amcheck .................................................................................................. 2072
pg_basebackup .............................................................................................. 2078
pgbench ........................................................................................................ 2087
pg_config ..................................................................................................... 2108
pg_dump ...................................................................................................... 2111
pg_dumpall ................................................................................................... 2125
pg_isready .................................................................................................... 2132
pg_receivewal ............................................................................................... 2134
pg_recvlogical ............................................................................................... 2139
pg_restore ..................................................................................................... 2143
pg_verifybackup ............................................................................................ 2153
psql ............................................................................................................. 2156
reindexdb ...................................................................................................... 2201
vacuumdb ..................................................................................................... 2205
III. PostgreSQL Server Applications ......................................................................... 2211
initdb ........................................................................................................... 2212
pg_archivecleanup .......................................................................................... 2217
pg_checksums ............................................................................................... 2219
pg_controldata ............................................................................................... 2221
pg_ctl ........................................................................................................... 2222
pg_resetwal ................................................................................................... 2228
pg_rewind ..................................................................................................... 2232
pg_test_fsync ................................................................................................ 2236
pg_test_timing ............................................................................................... 2237
pg_upgrade ................................................................................................... 2241
pg_waldump ................................................................................................. 2250
postgres ........................................................................................................ 2253
postmaster .................................................................................................... 2261
VII. Internals ................................................................................................................. 2262
51. Overview of PostgreSQL Internals ...................................................................... 2269
51.1. The Path of a Query ............................................................................... 2269
51.2. How Connections Are Established ............................................................ 2269
51.3. The Parser Stage .................................................................................... 2270
51.4. The PostgreSQL Rule System .................................................................. 2271
51.5. Planner/Optimizer .................................................................................. 2271
51.6. Executor ............................................................................................... 2273
52. System Catalogs ............................................................................................... 2274
xvi