Search PostgreSQL documentation

supamonitorExtensionsExtensionsPreloaded pgrx query hook that logs query text, query ID, planning time, and execution time as JSON. executor-hook query-monitoring query-text telemetry supamonitor MonitoringMonitoring · Extensions supasessionExtensionsExtensionsAdvanced session management for Supabase. database.dev postgresql-extension session-management supabase supabase-auth tle supasession SecuritySecurity · Extensions supautilsExtensionsExtensionsExtension that secures a cluster on a cloud environment supabase supautils SecuritySecurity · Extensions superloglog_counterExtensionsExtensionsC data type, functions, and aggregates for approximate distinct counting with the SuperLogLog algorithm. aggregate count distinct-estimation estimator superloglog distinct_estimators Functio…Functions and aggregates · Extensions suuidExtensionsExtensionssmall UUID extension postgresql primary-key uuid suuid Data typesData types · Extensions sveddyExtensionsExtensionsA PostgreSQL extension for collaborative filtering using low-rank matrix approximation techniques. sveddy AI and vectorsAI and vectors · Extensions svsExtensionsExtensionsSVS Vamana approximate-nearest-neighbor index with LeanVec and LVQ compression for pgvector. vector vamana leanvec ann svs AI and vectorsAI and vectors · Extensions sybase_fdwExtensionsExtensionsC foreign data wrapper for accessing Sybase databases from PostgreSQL. fdw foreign-data-wrapper sybase sybase_fdw Foreign data wrappersForeign data wrappers · Extensions symbiotic_pythonExtensionsExtensionsPrototype pgrx/Python bridge that creates per-database virtual environments and launches an asyncpg LISTEN service. command-execution pgrx python virtualenv symbiotic_python UtilitiesUtilities · Extensions synchdbExtensionsExtensionsMixed C/Java PostgreSQL extension for direct CDC replication from MySQL, SQL Server, Oracle, and OpenLog Replicator sources. cdc debezium etl heterogeneous-replication replication synchdb Re…Replication and streams · Extensions synchro_pgExtensionsExtensionsDatabase-side offline-first synchronization with scoped change capture sync offline-first logical-decoding synchro Replication and streamsReplication and streams · Extensions synchronize_logical_slotsExtensionsExtensionsSynchronizes logical replication slots from an EDB Advanced Server 12 primary to synchronous standby servers. dblink logical-replication replication-slot standby synchronization synchronize_…Replication and streams · Extensions sys_syn_dblinkExtensionsExtensionsPL/pgSQL synchronization processor that pulls sys_syn queues over named dblink connections, transforms batches, writes local tables, and returns processing status to the source database. dbl…Replication and streams · Extensions system_statsExtensionsExtensionsEnterpriseDB system statistics for PostgreSQL system_stats MonitoringMonitoring · Extensions tab_tierExtensionsExtensionsPL/pgSQL extension for job-driven retention, tiering, and date-based table partition maintenance. archival partitioning retention tiering tab_tier AnalyticsAnalytics · Extensions table_builderExtensionsExtensionsProof-of-concept for a safe rust table builder and querier table_builder FeaturesFeatures · Extensions table_change_trackerExtensionsExtensionsTracks last modification timestamps for selected tables in shared memory. table change timestamp hook table_change_tracker MonitoringMonitoring · Extensions table_guardExtensionsExtensionsConfigurable protection against DROP, TRUNCATE, and unqualified whole-table DELETE. ddl truncate delete guard pg_table_guard SecuritySecurity · Extensions table_logExtensionsExtensionsrecord table modification logs and PITR for table/row table_log AdministrationAdministration · Extensions table_log_plExtensionsExtensionsPL/pgSQL drop-in replacement for the table_log trigger-based DML auditing extension. audit dml logging trigger table_log_pl SecuritySecurity · Extensions table_vaultExtensionsExtensionsHistorical RLS application-identity example using a private session table rls authentication example rls-examples SecuritySecurity · Extensions table_versionExtensionsExtensionsPostgreSQL table versioning extension pgdg-flaw table_version Time seriesTime series · Extensions tablefuncExtensionsPG18F.43. tablefunc — functions that return tables (crosstab and others) The tablefunc module includes various functions that return tables (that is, multiple rows). These functions are useful b…tablefunc — functions that return tables (crosstab and others) tablelogExtensionsExtensionsTrigger-based audit and change-data-capture extension that records INSERT, UPDATE, and DELETE row images in a central log table and can generate replay SQL. audit change-data-capture logging…Security · Extensions tag_parserExtensionsExtensionsPostgreSQL Text Search parser extension for character separated lexemes fulltext postgresql postgresql-extension tags tag_parser Full-text searchFull-text search · Extensions tagextExtensionsExtensionsTag Programming Example Extension tagext Functions and aggregatesFunctions and aggregates · Extensions talib_extExtensionsExtensionspostgres extension to do technical analysis on postgres talib_ext Functions and aggregatesFunctions and aggregates · Extensions tanimotoExtensionsExtensionsFast C implementation of the Tanimoto similarity coefficient for PostgreSQL bit-varying fingerprints. bit-varying fingerprint similarity tanimoto tanimoto Functions and aggregatesFunctions and aggregates · Extensions taskbossExtensionsExtensionsPostgres extension for queueing jobs like a boss job pgrx postgres postgres-extension queue taskboss FeaturesFeatures · Extensions tbase_gts_toolsExtensionsExtensionsTBase helpers for inspecting transaction global timestamps and heap-page tuple metadata. tbase_gts_tools AdministrationAdministration · Extensions tblsize_nolockExtensionsExtensionsFunctions to calculate relation size without grabbing AccessShareLock on a target relation. tblsize_nolock AdministrationAdministration · Extensions tceExtensionsExtensionsTransparent column encryption for PostgreSQL using per-role envelope keys and external key-management services. encryption kms pgrx security tce SecuritySecurity · Extensions tcleExtensionsExtensionsExperimental table access method for transparent AES-256-CBC encryption of selected column types. aes cell-encryption experimental table-access-method tcle SecuritySecurity · Extensions tcnExtensionsPG18F.44. tcn — a trigger function to notify listeners of changes to table content The tcn module provides a trigger function that notifies listeners of changes to any table on which it is attac…tcn — a trigger function to notify listeners of changes to table content tcn_jsonExtensionsExtensionsC trigger function that sends primary-key change notifications through LISTEN/NOTIFY. change-data-capture json listen-notify trigger tcn_json Replication and streamsReplication and streams · Extensions tdigestExtensionsExtensionsProvides tdigest aggregate function. tdigest Functions and aggregatesFunctions and aggregates · Extensions tds_fdwExtensionsExtensionsForeign data wrapper for querying a TDS database (Sybase or Microsoft SQL Server) tds_fdw Foreign data wrappersForeign data wrappers · Extensions telephoneExtensionsExtensionsPostgreSQL data type for normalized telephone numbers with dialing-plan validation. data-type telephone validation telephone Data typesData types · Extensions template_fdwExtensionsExtensionsForeign data wrapper for template tables that intentionally rejects SELECT and DML operations. development foreign-data-wrapper template template_fdw Foreign data wrappersForeign data wrappers · Extensions temporalExtensionsExtensionsC extension providing a PERIOD type over timestamp-with-time-zone values, temporal relation operators and functions, plus GiST indexing support. period temporal time temporal Time seriesTime series · Extensions