Search PostgreSQL documentation

pg_basebackup --write-recovery-confCommand-line ToolsPG18pg_basebackup › OptionsR--write-recovery-conf Creates a standby.signal file and appends connection settings to the postgresql.auto.conf file in the target directory (or within the base archive file when using tar … pg_bech32ExtensionsExtensionsUtilities · ExtensionsAdds Bech32, Bech32m, and no-checksum Bech32 encoding/decoding support to PostgreSQL. pgrx pg_bech32 Utilities pg_bedtools_rsExtensionsExtensionsFunctions and aggregates · ExtensionsA PostgreSQL plugin for bedtools, implemented in Rust. bedtools genomics pgrx pg_bedtools_rs Functions and aggregates pg_bertExtensionsExtensionsFull-text search · ExtensionsBERT tokenizer implemented as a PostgreSQL full-text-search parser. pg_bert Full-text search pg_bestmatchExtensionsExtensionsFull-text search · ExtensionsGenerate BM25 sparse vector inside PostgreSQL pgrx pg_bestmatch Full-text search pg_bigmExtensionsExtensionsFull-text search · Extensionscreate 2-gram (bigram) index for faster full text search. pg_bigm Full-text search pg_bigmrExtensionsExtensionsFull-text search · Extensionstext similarity measurement and index searching based on bigrams full-text-search indexing pgrx pg_bigmr Full-text search pg_bikram_sambatExtensionsExtensionsData types · ExtensionsBikram Sambat date type and AD/BS conversion functions pg_bikram_sambat Data types pg_biscuitExtensionsExtensionsFull-text search · ExtensionsA fast bitmap-based index for PostgreSQL bitmap deterministic indexing like matching pattern search wildcard pg_biscuit Full-text search pg_bitcoin_addressExtensionsExtensionsData types · ExtensionsBitcoin address types plus Base58Check and Bech32/Bech32m codecs. bitcoin base58 bech32 address pg_bitcoin_address Data types pg_bitcountExtensionsExtensionsFunctions and aggregates · ExtensionsBit-count scalar and aggregate functions for integers and bit strings. bitcount bitmap aggregate integer pg_bitcount Functions and aggregates pg_bleveExtensionsExtensionsFull-text search · ExtensionsPostgreSQL extension for Bleve search integration bleve full-text-search index pg_bleve Full-text search pg_blkchainExtensionsExtensionsFunctions and aggregates · ExtensionsC extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL. pg_blkchain Functions and aggregates pg_block_if_slowExtensionsExtensionsAdministration · ExtensionsAbort queries that are taking too long based on EXPLAIN estimates. pg_block_if_slow Administration pg_block_systemcatalogExtensionsExtensionsSecurity · ExtensionsPostgreSQL extension to block references to system catalogs. access-control catalog security pg_block_systemcatalog Security pg_bloomExtensionsExtensionsData types · ExtensionsPrototype 64-bit single-item Bloom-like data type and membership operator pg_bloom Data types pg_bm25ExtensionsExtensionsFull-text search · ExtensionsFull text search for PostgreSQL using BM25 bm25 full-text-search pgrx tantivy pg_bm25 Full-text search pg_bmanExtensionsExtensionsAdministration · ExtensionsPostgreSQL hot-backup tooling with remote full/incremental backup and archive-log helpers. pg_bman Administration pg_bofhExtensionsExtensionsAdministration · ExtensionsRejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries. hook planner preload pg_bofh Administration pg_branchExtensionsExtensionsFeatures · ExtensionsPostgreSQL extension for quickly creating copies of databases and clusters. btrfs database-branching pgrx snapshot pg_branch Features pg_buffercacheExtensionsPG18pg_buffercache — inspect PostgreSQL buffer cache stateinspect PostgreSQL buffer cache state The pg_buffercache module provides a means for examining what's happening in the shared buffer cache in real time. It also offers a low-level way to evi… pg_buffercache — inspect PostgreSQL buffer cache stateManual ChaptersPG18The pg_buffercache module provides a means for examining what's happening in the shared buffer cache in real time. It also offers a low-level way to evict data from it, for testing purposes.… pg_bulkloadExtensionsExtensionsReplication and streams · Extensionsis a high speed data loading utility for PostgreSQL pg_bulkload Replication and streams pg_cache_treeExtensionsExtensionsFeatures · ExtensionsCaches recursive parent and child IDs in array columns using trigger and helper functions. cache hierarchy tree trigger pg_cache_tree Features pg_calcpiExtensionsExtensionsFunctions and aggregates · ExtensionsComputes digits of pi in PostgreSQL with a PL/pgSQL spigot algorithm. math plpgsql pg_calcpi Functions and aggregates pg_cardanoExtensionsExtensionsFeatures · ExtensionsA suite of Cardano-related tools pgrx pg_cardano Features pg_castManual ChaptersPG18The catalog pg_cast stores data type conversion paths, both built-in and user-defined. It should be noted that pg_cast does not represent every type conversion that the system knows how to p… pg_catalog_get_defsExtensionsExtensionsAdministration · ExtensionsAdds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata. catalog ddl introspection pg_catalog_get_defs Administration pg_catcheckExtensionsExtensionsAdministration · ExtensionsDiagnosing system catalog corruption pg_catcheck Administration pg_celExtensionsExtensionsSecurity · ExtensionsA pure PostgreSQL implementation of the Google Zanzibar / OpenFGA authorization model. pg_cel Security pg_cextExtensionsExtensionsFunctions and aggregates · ExtensionsA PostgreSQL extension to add two numbers addition c custom extension gsoc postgresql postgresql-extension tutorial pg_cext Functions and aggregates pg_cgroupExtensionsExtensionsAdministration · ExtensionsProvides SQL-callable functions to create, configure, and attach processes to Linux cgroups. cgroup resource-control shared-preload pg_cgroup Administration pg_chainsyncExtensionsExtensionsReplication and streams · ExtensionsAccess blockchain blocks, events, and tasks directly inside PostgreSQL using background workers. background-worker blockchain pgrx pg_chainsync Replication and streams pg_chainutilsExtensionsExtensionsData types · ExtensionsBlockchain utility types and functions for PostgreSQL, built with pgrx. pgrx pg_chainutils Data types pg_change_point_detectionExtensionsExtensionsTime series · ExtensionsA Postgres extension to detect change points in time series data pg_change_point_detection Time series pg_chaos_shuffleExtensionsExtensionsFeatures · ExtensionsChaos-testing hook that randomizes SELECT results lacking ORDER BY. chaos ordering testing executor-hook pg_chaos_shuffle Features pg_cheat_funcsExtensionsExtensionsAdministration · ExtensionsProvides cheat (but useful) functions pg_cheat_funcs Administration pg_checkExtensionsExtensionsAdministration · ExtensionsProvides basic integrity checks for data files. check corruption data integrity structure pg_check Administration pg_checkdestroyExtensionsExtensionsAdministration · Extensionscheck sql drop&delete&truncate table destructive-statement guard shared-preload pg_checkdestroy Administration pg_checksumsManual ChaptersPG18enable, disable or check data checksums in a PostgreSQL database cluster Synopsis pg_checksums [option...] [[ -D | --pgdata ]datadir]