Search PostgreSQL documentation

pg_tamperlogExtensionsExtensionsSecurity · ExtensionsTamper-evident append-only audit logging with hash chaining pg_tamperlog Security pg_tamperlog_rustExtensionsExtensionsSecurity · ExtensionsRust pgrx helper extension for pg_tamperlog fast SHA-256 hash-chain calculations. pgrx pg_tamperlog Security pg_taskExtensionsExtensionsTime series · Extensionsexecute any sql command at any specific time at background pg_task Time series pg_tdeExtensionsExtensionsSecurity · ExtensionsPercona pg_tde access method fork pgtde pg_tde Security pg_temporalExtensionsExtensionsData types · ExtensionsPostgreSQL extension adding Temporal ZonedDateTime support. pgrx pg_temporal Data types pg_test_fsyncManual ChaptersPG18determine fastest wal_sync_method for PostgreSQL Synopsis pg_test_fsync [option...] pg_test_timingManual ChaptersPG18measure timing overhead Synopsis pg_test_timing [option...] pg_testgenExtensionsExtensionsFunctions and aggregates · ExtensionsGenerate random integers, strings, and test-data rows for PostgreSQL development random test-data testing pg_testgen Functions and aggregates pg_text_semverExtensionsExtensionsData types · ExtensionsSemantic version domain and comparison operators for PostgreSQL pg_text_semver Data types pg_textparserExtensionsExtensionsFull-text search · ExtensionsText search parser pg_textparser Full-text search pg_textsearchExtensionsExtensionsFull-text search · ExtensionsFull-text search with BM25 ranking pg_textsearch Full-text search pg_themisExtensionsExtensionsSecurity · ExtensionsPostgreSQL encryption and decryption functions backed by the Themis cryptographic library. cryptography encryption themis pg_themis Security pg_thriftExtensionsExtensionsData types · ExtensionsEncode, decode, and query Apache Thrift binary and compact protocol values in PostgreSQL. binary-protocol serialization thrift pg_thrift Data types pg_thudExtensionsExtensionsFeatures · ExtensionsFramework extending pgtap with scaffolding and test-data helpers for database unit tests. pg_thud Features pg_tierExtensionsExtensionsAnalytics · ExtensionsTier PostgreSQL table data to external S3 storage through parquet_s3_fdw. fdw pgrx s3 tembo tiering pg_tier Analytics pg_tigerbeetleExtensionsExtensionsUtilities · ExtensionsExperimental Zig extension for looking up TigerBeetle accounts from PostgreSQL. pg_tigerbeetle Utilities pg_tiktokenExtensionsExtensionsAI and vectors · Extensionstiktoken tokenizer for use with OpenAI models in postgres pgrx pg_tiktoken AI and vectors pg_tiktoken_cExtensionsExtensionsAI and vectors · ExtensionsFast tiktoken BPE tokenizer for PostgreSQL implemented in C tokenizer tiktoken openai pg_tiktoken_c AI and vectors pg_tilelessExtensionsExtensionsGeospatial · ExtensionsTools for packaging twkb in sqlite for tileless pg_tileless Geospatial pg_timelordExtensionsExtensionsTime series · ExtensionsProof-of-concept time-travel queries using commit timestamps and a custom MVCC snapshot. commit-timestamp mvcc time-travel pg_timelord Time series pg_timeoutExtensionsExtensionsAdministration · ExtensionsPostgreSQL background-worker extension for terminating idle database sessions. idle-sessions session-timeout shared-preload pg_timeout Administration pg_timersExtensionsExtensionsTime series · ExtensionsSchedule SQL execution at exact times or after intervals in PostgreSQL background-worker citus scheduling timer pg_timers Time series pg_timezone_abbrevsManual ChaptersPG18The view pg_timezone_abbrevs provides a list of time zone abbreviations that are currently recognized by the datetime input routines. The contents of this view change when the TimeZone or ti… pg_timezone_namesManual ChaptersPG18The view pg_timezone_names provides a list of time zone names that are recognized by SET TIMEZONE, along with their associated abbreviations, UTC offsets, and daylight-savings status. (Techn… pg_tleExtensionsExtensionsProcedural languages · ExtensionsTrusted Language Extensions for PostgreSQL both pg_tle Procedural languages pg_tm_auxExtensionsExtensionsReplication and streams · ExtensionsTransfer manager auxiliary functions pg_tm_aux Replication and streams pg_tmsExtensionsExtensionsGeospatial · Extensionsfunctions to tile rasters in TMS format pg_tms Geospatial pg_toastinspectExtensionsExtensionsAdministration · ExtensionsLow-level inspection of TOAST chunk identifiers, sizes, and stored values. toast storage inspection catalog pg_toastinspect Administration pg_toastutilsExtensionsExtensionsAdministration · ExtensionsTOAST inspection utils for postgres pg_toastutils Administration pg_tokenizerExtensionsExtensionsFull-text search · ExtensionsTokenizers for full-text search pgrx pg_tokenizer Full-text search pg_toolkit_brazilExtensionsExtensionsData types · ExtensionsBrazilian CPF and CNPJ types, validation, formatting, casts, and operators. brazil cpf cnpj type pg_toolkit_brazil Data types pg_tpchExtensionsExtensionsFeatures · ExtensionsTPC-H table creation, data loading, and query metadata for PostgreSQL benchmark data-generation pgrx tpc-h pg_tpch Features pg_traceExtensionsExtensionsMonitoring · ExtensionsQuery execution tracing with shared-memory buffers, persistence, and retention controls. query trace performance shared-memory pg_trace Monitoring pg_tracingExtensionsExtensionsMonitoring · ExtensionsDistributed Tracing for PostgreSQL pg_tracing Monitoring pg_track_optimizerExtensionsExtensionsMonitoring · ExtensionsTrack planning decisions in comparison with execution reality pg_track_optimizer Monitoring pg_track_settingsExtensionsExtensionsMonitoring · ExtensionsTrack settings changes pg_track_settings Monitoring pg_track_slow_queriesExtensionsExtensionsMonitoring · ExtensionsTracks slow queries and their execution plans pg_track_slow_queries Monitoring pg_trajectoryExtensionsExtensionsGeospatial · ExtensionsDefine PostGIS trajectory types and spatiotemporal analysis functions in SQL and PL/pgSQL postgis spatiotemporal trajectory pg_trajectory Geospatial pg_transformManual ChaptersPG18The catalog pg_transform stores information about transforms, which are a mechanism to adapt data types to procedural languages. See CREATE TRANSFORM for more information. Table 52.57. pg_tr… pg_transportExtensionsExtensionsReplication and streams · ExtensionsAmazon RDS extension for transportable PostgreSQL database workflows. aws-rds database-migration physical-transport shared-preload pg_transport Replication and streams