Search PostgreSQL documentation

pg_bigmrExtensionsExtensionstext similarity measurement and index searching based on bigrams full-text-search indexing pgrx pg_bigmr Full-text searchFull-text search · Extensions pg_bikram_sambatExtensionsExtensionsBikram Sambat date type and AD/BS conversion functions pg_bikram_sambat Data typesData types · Extensions pg_biscuitExtensionsExtensionsA fast bitmap-based index for PostgreSQL bitmap deterministic indexing like matching pattern search wildcard pg_biscuit Full-text searchFull-text search · Extensions pg_bitcoin_addressExtensionsExtensionsBitcoin address types plus Base58Check and Bech32/Bech32m codecs. bitcoin base58 bech32 address pg_bitcoin_address Data typesData types · Extensions pg_bitcountExtensionsExtensionsBit-count scalar and aggregate functions for integers and bit strings. bitcount bitmap aggregate integer pg_bitcount Functions and aggregatesFunctions and aggregates · Extensions pg_bleveExtensionsExtensionsPostgreSQL extension for Bleve search integration bleve full-text-search index pg_bleve Full-text searchFull-text search · Extensions pg_blkchainExtensionsExtensionsC extension providing Bitcoin blockchain parsing and helper functions for PostgreSQL. pg_blkchain Functions and aggregatesFunctions and aggregates · Extensions pg_block_if_slowExtensionsExtensionsAbort queries that are taking too long based on EXPLAIN estimates. pg_block_if_slow AdministrationAdministration · Extensions pg_block_systemcatalogExtensionsExtensionsPostgreSQL extension to block references to system catalogs. access-control catalog security pg_block_systemcatalog SecuritySecurity · Extensions pg_blocking_pidsFunctionsReferencepg_blocking_pids System Information Functions And Operators 10 Process ID(s) that are blocking specified server process ID from acquiring a lock pg_blocking_pids ( int ) → int[] Process ID(s…Functions · System Information Functions And Operators pg_bloomExtensionsExtensionsPrototype 64-bit single-item Bloom-like data type and membership operator pg_bloom Data typesData types · Extensions pg_bm25ExtensionsExtensionsFull text search for PostgreSQL using BM25 bm25 full-text-search pgrx tantivy pg_bm25 Full-text searchFull-text search · Extensions pg_bmanExtensionsExtensionsPostgreSQL hot-backup tooling with remote full/incremental backup and archive-log helpers. pg_bman AdministrationAdministration · Extensions pg_bofhExtensionsExtensionsRejects queries without WHERE clauses using a planner hook loaded via shared_preload_libraries. hook planner preload pg_bofh AdministrationAdministration · Extensions pg_branchExtensionsExtensionsPostgreSQL extension for quickly creating copies of databases and clusters. btrfs database-branching pgrx snapshot pg_branch FeaturesFeatures · Extensions pg_buffercacheExtensionsPG18F.25. pg_buffercache — inspect 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…pg_buffercache — inspect PostgreSQL buffer cache state pg_buffercache — inspect PostgreSQL buffer cache stateManual ChaptersPG18F.25. pg_buffercache — inspect 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…pg_buffercache — inspect PostgreSQL buffer cache state pg_bulkloadExtensionsExtensionspg_bulkload is a high speed data loading utility for PostgreSQL pg_bulkload Replication and streamsReplication and streams · Extensions pg_cache_treeExtensionsExtensionsCaches recursive parent and child IDs in array columns using trigger and helper functions. cache hierarchy tree trigger pg_cache_tree FeaturesFeatures · Extensions pg_calcpiExtensionsExtensionsComputes digits of pi in PostgreSQL with a PL/pgSQL spigot algorithm. math plpgsql pg_calcpi Functions and aggregatesFunctions and aggregates · Extensions pg_cancel_backendFunctionsReferencepg_cancel_backend System Administration Functions 10 Cancel a backend's current query. This is also allowed if the calling role is a member of the role whose backend is being canceled or the…Functions · System Administration Functions pg_cardanoExtensionsExtensionsA suite of Cardano-related tools pgrx pg_cardano FeaturesFeatures · Extensions pg_castManual ChaptersPG1852.10. pg_cast The 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…pg_cast pg_castCatalogs & ViewsReferencepg_cast System catalogs 10 The 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 th…System Catalogs · System catalogs pg_catalog_get_defsExtensionsExtensionsAdds PL/pgSQL functions that reconstruct CREATE TYPE definitions from pg_catalog metadata. catalog ddl introspection pg_catalog_get_defs AdministrationAdministration · Extensions pg_catcheckExtensionsExtensionsDiagnosing system catalog corruption pg_catcheck AdministrationAdministration · Extensions pg_celExtensionsExtensionsA pure PostgreSQL implementation of the Google Zanzibar / OpenFGA authorization model. pg_cel SecuritySecurity · Extensions pg_cextExtensionsExtensionsA PostgreSQL extension to add two numbers addition c custom extension gsoc postgresql postgresql-extension tutorial pg_cext Functions and aggregatesFunctions and aggregates · Extensions pg_cgroupExtensionsExtensionsProvides SQL-callable functions to create, configure, and attach processes to Linux cgroups. cgroup resource-control shared-preload pg_cgroup AdministrationAdministration · Extensions pg_chainsyncExtensionsExtensionsAccess blockchain blocks, events, and tasks directly inside PostgreSQL using background workers. background-worker blockchain pgrx pg_chainsync Replication and streamsReplication and streams · Extensions pg_chainutilsExtensionsExtensionsBlockchain utility types and functions for PostgreSQL, built with pgrx. pgrx pg_chainutils Data typesData types · Extensions pg_change_point_detectionExtensionsExtensionsA Postgres extension to detect change points in time series data pg_change_point_detection Time seriesTime series · Extensions pg_chaos_shuffleExtensionsExtensionsChaos-testing hook that randomizes SELECT results lacking ORDER BY. chaos ordering testing executor-hook pg_chaos_shuffle FeaturesFeatures · Extensions pg_char_to_encodingFunctionsReferencepg_char_to_encoding System Information Functions And Operators 15 Converts the supplied encoding name into an integer representing the internal identifier used in some system catalog tables.…Functions · System Information Functions And Operators pg_cheat_funcsExtensionsExtensionsProvides cheat (but useful) functions pg_cheat_funcs AdministrationAdministration · Extensions pg_checkExtensionsExtensionsProvides basic integrity checks for data files. check corruption data integrity structure pg_check AdministrationAdministration · Extensions pg_checkdestroyExtensionsExtensionscheck sql drop&delete&truncate table destructive-statement guard shared-preload pg_checkdestroy AdministrationAdministration · Extensions pg_checksumsCommand-line ToolsPG18pg_checksums pg_checksums — enable, disable or check data checksums in a PostgreSQL database cluster Synopsis pg_checksums [option...] [[ -D | --pgdata ]datadir]pg_checksums pg_checksumsManual ChaptersPG18pg_checksums pg_checksums — enable, disable or check data checksums in a PostgreSQL database cluster Synopsis pg_checksums [option...] [[ -D | --pgdata ]datadir]pg_checksums pg_checksumsExtensionsExtensionsActivate/deactivate/verify checksums in offline Postgres clusters bin pg_checksums AdministrationAdministration · Extensions