Search PostgreSQL documentation

temporal_rtreeExtensionsExtensionsExperimental temporal R-tree access method implemented as a PostgreSQL extension. temporal_rtree Time seriesTime series · Extensions temporal_tablesExtensionsExtensionstemporal tables pgdg-flaw temporal_tables Time seriesTime series · Extensions tencentdb_aiExtensionsExtensionsTencentDB extension for calling large-model APIs and building in-database RAG workflows. ai llm rag tencentdb_ai AI and vectorsAI and vectors · Extensions tencentdb_failover_slotExtensionsExtensionsTencentDB proprietary kernel extension that synchronizes logical replication-slot state to standby nodes so subscriptions can continue across primary/standby failover. failover high-availabi…Replication and streams · Extensions tencentdb_pwdcheckExtensionsExtensionsTencentDB password-policy extension loaded at server startup to enforce strong passwords. password security tencentdb_pwdcheck SecuritySecurity · Extensions tencentdb_serverlessExtensionsExtensionsTencentDB extension for per-database CPU resource isolation in serverless and multi-tenant workloads. resource-control serverless tencentdb_serverless AdministrationAdministration · Extensions tencentdb_sql_throttlingExtensionsExtensionsTencentDB proprietary preloaded extension for limiting SQL concurrency by normalized SQL text or query ID across primary and read-only nodes. concurrency-control queryid resource-control sql…Administration · Extensions tencentdb_statExtensionsExtensionsTencentDB provider extension for collecting PostgreSQL QPS statistics. qps statistics tencentdb_stat MonitoringMonitoring · Extensions tencentdb_superuserExtensionsExtensionsTencentDB administration extension that supplies the managed pg_tencentdb_superuser role and privileges. administration privilege-management roles tencentdb_superuser SecuritySecurity · Extensions tencentdb_system_statExtensionsExtensionsTencentDB extension that exposes per-process CPU and memory usage for PostgreSQL monitoring. process-monitoring resource-usage statistics tencentdb_system_stat MonitoringMonitoring · Extensions tencentdb_wal_statExtensionsExtensionsTencentDB proprietary WAL diagnostics extension that scans recent WAL files and attributes record counts, bytes, resource-manager types, and full-page images by database, schema, and relatio…Monitoring · Extensions test_decodingExtensionsPG18F.45. test_decoding — SQL-based test/example module for WAL logical decoding test_decoding is an example of a logical decoding output plugin. It doesn't do anything especially useful, but ca…test_decoding — SQL-based test/example module for WAL logical decoding test_factoryExtensionsExtensionsFramework for registering, creating, caching, and reusing named PostgreSQL test data sets. test-data test-factory testing unit-testing test_factory FeaturesFeatures · Extensions test_factory_pgtapExtensionsExtensionsA framework for managing test data test data test factory testing tests unit test test_factory FeaturesFeatures · Extensions test_parserExtensionsExtensionsExample C extension implementing a custom PostgreSQL full-text-search parser. custom-parser example full-text-search parser test_parser Full-text searchFull-text search · Extensions texcallerExtensionsExtensionsPostgreSQL functions for converting TeX or LaTeX source to DVI or PDF. document-conversion latex tex texcaller UtilitiesUtilities · Extensions text_domainsExtensionsExtensionsPure-SQL collection of constrained PostgreSQL text domains for nonempty, alphabetic, alphanumeric, case-specific, and fixed-length values. alphanumeric domain text validation text_domains Da…Data types · Extensions text_funcsExtensionsExtensionsTutorial 3 text functions text_funcs Functions and aggregatesFunctions and aggregates · Extensions tg_sanityExtensionsExtensionsTrigger function for enforcing data quality. constraint data quality trigger tg_sanity FeaturesFeatures · Extensions tg_sanity_tapExtensionsExtensionspgtap testing function for tg sanity triggers constraint data quality trigger tg_sanity FeaturesFeatures · Extensions th_dbdmExtensionsExtensionsth dbdm: Postgres for database data management pgrx rust th_dbdm AnalyticsAnalytics · Extensions thai_parserExtensionsExtensionsThai-language parser and text search configuration for PostgreSQL full-text search. fts parser thai thai_parser Full-text searchFull-text search · Extensions tibero_fdwExtensionsExtensionsPostgreSQL foreign data wrapper source code for Tibero tibero_fdw Foreign data wrappersForeign data wrappers · Extensions time_for_keysExtensionsExtensionsC and PL/pgSQL helpers that enforce temporal foreign keys between valid-time tables with constraint triggers. foreign-key referential-integrity state-time temporal time_for_keys Time seriesTime series · Extensions timefluxExtensionsExtensionsTimeFlux+: Advanced Time-Series Storage Engine timeflux Time seriesTime series · Extensions timeitExtensionsExtensionsHigh-resolution benchmarking of PostgreSQL built-in functions and SQL expressions. benchmarking high-resolution-timing performance timeit MonitoringMonitoring · Extensions timeqlExtensionsExtensionsNative temporal history tracking and point-in-time queries using PostgreSQL range types and GiST indexes. postgresql timeql Time seriesTime series · Extensions timescaledbExtensionsExtensionsEnables scalable inserts and complex queries for time-series data timescaledb Time seriesTime series · Extensions timescaledb_toolkitExtensionsExtensionsLibrary of analytical hyperfunctions, time-series pipelining, and other SQL utilities pgrx timescaledb_toolkit Time seriesTime series · Extensions timeseriesExtensionsExtensionsConvenience API for time series stack pg_timeseries Time seriesTime series · Extensions timestamp9ExtensionsExtensionstimestamp nanosecond resolution timestamp9 Data typesData types · Extensions timestampandtzExtensionsExtensionsC data type that stores a timestamp together with its source time-zone identity, with casts, operators, indexing, and date/time functions. datetime timestamp timezone type timestampandtz Dat…Data types · Extensions timetravelExtensionsExtensionsTencentDB for PostgreSQL provider extension named timetravel, available as version 1.0 on PostgreSQL 10 and 11. provider-only time-travel timetravel Time seriesTime series · Extensions tinExtensionsExtensionsTIN-compatible text search for development and testing text-search tinql testing lead Full-text searchFull-text search · Extensions tinyintExtensionsExtensionsOne-byte signed integer type with arithmetic, casts, aggregates, and B-tree, hash, and GIN operator classes. btree data-type gin hash-index integer tinyint tinyint-postgresql Data typesData types · Extensions tlsh_gistExtensionsExtensionsTLSH fuzzy-hash data type, distance operations, and GiST indexing for similarity search. tlsh_gist AI and vectorsAI and vectors · Extensions tm_postgres_basicsExtensionsExtensionsPL/pgSQL helper functions for resolving relation OIDs and traversing table inheritance. functions inheritance plpgsql tm-postgres-basics Functions and aggregatesFunctions and aggregates · Extensions toastExtensionsExtensionsTutorial 7 TOAST toast AdministrationAdministration · Extensions toastinfoExtensionsExtensionsshow details on toasted datums toastinfo MonitoringMonitoring · Extensions topnExtensionsExtensionstype for top-n JSONB topn Functions and aggregatesFunctions and aggregates · Extensions