Search PostgreSQL documentation

townExtensionsExtensionsMinimal PL/pgSQL helper that creates JSONB-and-array time-series tables with GIN and GiST indexes. jsonb time-series utility town Time seriesTime series · Extensions traceamExtensionsExtensionsSimple table access method that just prints out what functions in the access methods and related functions that are called. traceam FeaturesFeatures · Extensions track_renamesExtensionsExtensionsEvent-trigger function that forwards PostgreSQL object rename details to a configurable callback. ddl event-trigger rename-tracking postgresql_track_renames AdministrationAdministration · Extensions translate_isbnExtensionsExtensionsC function that converts text ISBN codes between ISBN-10 and ISBN-13 forms for Evergreen-compatible search expansion. conversion isbn isbn10 isbn13 translate_isbn Functions and aggregatesFunctions and aggregates · Extensions treasuredata_fdwExtensionsExtensionsC foreign data wrapper backed by a Rust td-client bridge for querying and inserting Treasure Data datasets. fdw foreign-data-wrapper rust-bridge treasure-data treasuredata_fdw Foreign data w…Foreign data wrappers · Extensions tree_similarity_extensionExtensionsExtensionsHello-world pgrx stub extension whose repository does not yet implement tree-similarity functions. hello-world pgrx stub tree_similarity_extension FeaturesFeatures · Extensions treedb_pgextExtensionsExtensionsTreeDB table access method (Phase 0 prototype) treedb_pgext FeaturesFeatures · Extensions triangle_arrayExtensionsExtensionsPrototype PostgreSQL representation of triangulated irregular networks using compact point and triangle arrays. tin triangle wkb trianglearray GeospatialGeospatial · Extensions trimmed_aggregatesExtensionsExtensionsC aggregate functions that discard configurable low/high outliers before computing averages, variances, and standard deviations. aggregate outlier statistics trimmed trimmed_aggregates Funct…Functions and aggregates · Extensions trunkfingerprintExtensionsExtensionsComputes comparable fingerprints of PostgreSQL database structure and optionally data. comparison fingerprint hash structure trunkfingerprint AdministrationAdministration · Extensions trunkletExtensionsExtensionsA templating system for Postgres. Elephants don't use templates, they use trunklets! meta meta programming template templates templating trunklet UtilitiesUtilities · Extensions trunklet-formatExtensionsExtensionsA format()-based template language for trunklet format meta meta programming metacode template trunklet trunklet-format UtilitiesUtilities · Extensions tsearch2ExtensionsExtensionsDeprecated Amazon RDS PostgreSQL 10 compatibility extension for applications using pre-8.3 tsearch2 full-text-search APIs. backward-compatibility deprecated full-text-search migration tsearc…Full-text search · Extensions tsearch_extrasExtensionsExtensionsFull-text-search helpers for returning match locations and extracting tsvector lexemes. full-text-search match-location tsquery tsvector tsearch_extras Full-text searchFull-text search · Extensions tsexactExtensionsExtensionsFull-text-search helpers for exact phrase matching on PostgreSQL 9.5 and earlier. exact-match full-text-search phrase-search tsexact Full-text searchFull-text search · Extensions tsexampleExtensionsExtensionsExample C extension that defines a custom full-text parser, dictionary template, dictionary, and text-search configuration. dictionary example full-text-search parser tsexample Full-text sea…Full-text search · Extensions tsf_fdwExtensionsExtensionsGolden Helix C foreign data wrapper for reading one or more TSF genomic data files as PostgreSQL foreign tables. fdw genomics tsf tsf_fdw Foreign data wrappersForeign data wrappers · Extensions tsm_system_rowsExtensionsPG18F.46. tsm_system_rows — the SYSTEM_ROWS sampling method for TABLESAMPLE The tsm_system_rows module provides the table sampling method SYSTEM_ROWS, which can be used in the TABLESAMPLE clause…tsm_system_rows — the SYSTEM_ROWS sampling method for TABLESAMPLE tsm_system_timeExtensionsPG18F.47. tsm_system_time — the SYSTEM_TIME sampling method for TABLESAMPLE The tsm_system_time module provides the table sampling method SYSTEM_TIME, which can be used in the TABLESAMPLE clause…tsm_system_time — the SYSTEM_TIME sampling method for TABLESAMPLE tsp_semantic_headlineExtensionsExtensionsPhrase highlighting and improved semantics for ts_headline full-text-search headline phrase-search tsquery tsp_semantic_headline Full-text searchFull-text search · Extensions tsurugi_fdwExtensionsExtensionsTsurugi Foreign Data Wrapper for PostgreSQL. fdw foreign-data-wrapper postgresql-extension postgressql sql tsurugidb tsurugi_fdw Foreign data wrappersForeign data wrappers · Extensions tsvector2ExtensionsExtensionsCompressed alternative to PostgreSQL tsvector without the original 1 MB limit, with compatible search functions and GIN, GiST, and optional RUM indexing. compression full-text-search gin gis…Full-text search · Extensions tuidExtensionsExtensionstuid datatype tuid Functions and aggregatesFunctions and aggregates · Extensions tuple_fdwExtensionsExtensionsProof-of-concept C foreign data wrapper for append-only, LZ4-compressed binary tuple files used as cold storage. append-only cold-storage compressed fdw lz4 tuple_fdw Foreign data wrappersForeign data wrappers · Extensions tuplockExtensionsExtensionslock tuples (rows) with a boolean attribute lock locking row trigger tuple tuplock AdministrationAdministration · Extensions twitter_fdwExtensionsExtensionsLegacy foreign data wrapper for the retired unauthenticated Twitter Search API. fdw internet social-media twitter web-api twitter_fdw Foreign data wrappersForeign data wrappers · Extensions twitter_parserExtensionsExtensionsMinimal C full-text-search parser that tokenizes Twitter-style hashtags and mentions. full-text-search hashtag mention parser twitter_parser Full-text searchFull-text search · Extensions typeidExtensionsExtensionsAllows to use TypeIDs in Postgres natively pgrx pg_typeid Functions and aggregatesFunctions and aggregates · Extensions typesExtensionsExtensionsReusable domains for attachments, email addresses, hostnames, images, uploads, and URLs. types Data typesData types · Extensions typesafeExtensionsExtensionsSQL client for TypeSafe AI classification and scoring classification ai http pg_typesafe AI and vectorsAI and vectors · Extensions tzfExtensionsExtensionsFast lookup timezone name by GPS coordinates pgrx pg_tzf GeospatialGeospatial · Extensions uidsExtensionsExtensionsPostgreSQL extension to generate various types of universally unique IDs cuid2 identifier ksuid nanoid pgrx typeid ulid uuid uids-postgres Functions and aggregatesFunctions and aggregates · Extensions uintExtensionsExtensionsunsigned integer types pgdg-flaw pguint Data typesData types · Extensions uint128ExtensionsExtensionsNative uint128 type pg_uint128 Data typesData types · Extensions uintsExtensionsExtensionsC extension providing unsigned 16-bit and 32-bit integer types with casts, operators, and numeric support functions. integer numeric type unsigned postgres_uints Data typesData types · Extensions ulakExtensionsExtensionsTransactional Outbox extension for PostgreSQL with reliable asynchronous delivery ulak FeaturesFeatures · Extensions ulidExtensionsExtensionsEmbedded pgrx ULID type, generators, and casts data-type identifier monotonic pgrx ulid uuid ulid Data typesData types · Extensions unaccentExtensionsPG18F.48. unaccent — a text search dictionary which removes diacritics unaccent is a text search dictionary that removes accents (diacritic signs) from lexemes. It's a filtering dictionary, whic…unaccent — a text search dictionary which removes diacritics undamExtensionsExtensionsUNDO storage table access method with in-place updates experimental mvcc table-access-method undo undam FeaturesFeatures · Extensions unidecodeExtensionsExtensionsASCII transliterations of Unicode text ascii translit transliteration unicode pg_unidecode Full-text searchFull-text search · Extensions