Search PostgreSQL documentation

shared_ispellExtensionsExtensionsShared-memory ispell dictionary template for reducing per-session initialization and memory. dictionary full-text-search ispell shared-memory shared_ispell Full-text searchFull-text search · Extensions sharkExtensionsExtensionsextension for D compatibility shark CompatibilityCompatibility · Extensions shbfExtensionsExtensionsC extension providing Bloom filter, shifting Bloom filter, and count-min sketch PostgreSQL data types and functions. bloom-filter count-min-sketch probabilistic shifting_bloom_filter Functio…Functions and aggregates · Extensions short_idsExtensionsExtensionsPL/pgSQL generator for short random text IDs with collision checks and transaction advisory locks. advisory-lock id-generator random text short_ids Functions and aggregatesFunctions and aggregates · Extensions showenvExtensionsExtensionsShow environment variables for a backend showenv AdministrationAdministration · Extensions sidExtensionsExtensionsSortable labeled 128-bit identifier type with compact human-readable encoding. pgrx rust sid Data typesData types · Extensions signed_vaultExtensionsExtensionsHistorical RLS application-identity example using signed session settings rls authentication example rls-examples SecuritySecurity · Extensions siguanet_questExtensionsExtensionsApplication-specific PL/pgSQL reporting layer for spatial aggregation over SIGUANET/PostGIS campus asset databases. asset-management geodatabase postgis reporting spatial-aggregation siguane…Geospatial · Extensions similarityExtensionsExtensionsC extension that computes a normalized similarity score between two strings using an fstrcmp-style approximate matching algorithm. approximate-matching string-similarity postgresql_similarit…Full-text search · Extensions simpleExtensionsExtensionspostgresql simple demo extension simple FeaturesFeatures · Extensions simple_parserExtensionsExtensionsC full-text-search parser that splits input only at ASCII space characters, preserving punctuation such as underscores inside tokens. full-text-search parser tokenization pg_simple_parser Fu…Full-text search · Extensions simple_timeseriesExtensionsExtensionstime-series extension simple_timeseries Time seriesTime series · Extensions simpleextExtensionsExtensionstrivial boilerplates, examples simpleext FeaturesFeatures · Extensions sixqlExtensionsExtensionsExperimental pgrx extension attempting to render SIXEL plots through PostgreSQL server output for compatible terminals. pgrx plotting sixel terminal visualization sixql UtilitiesUtilities · Extensions skitch-extension-defaultsExtensionsExtensionsdefault roles node-module npm postgresql skitch sqitch skitch-extension-defaults SecuritySecurity · Extensions skitch-extension-jobsExtensionsExtensionsAn asynchronous job queue schema for ACID compliant job creation node-module npm postgresql skitch sqitch skitch-extension-jobs FeaturesFeatures · Extensions skitch-extension-utilsExtensionsExtensionsPostgreSQL utilities dependency-closure skitch-extension-utils source-only sql skitch-extension-utils UtilitiesUtilities · Extensions skitch-extension-verifyExtensionsExtensionsPL/pgSQL catalog-verification functions for checking PostgreSQL objects, roles, privileges, policies, and other schema properties. catalog-validation plpgsql sqitch skitch-extension-verify A…Administration · Extensions slowjitExtensionsExtensionsA simple demo to illustrate how to implement a JIT provider for PostgreSQL. jit postgresql postgresql-extension slowjit Procedural languagesProcedural languages · Extensions slugifyExtensionsExtensionsPostgreSQL Extension to generate various variant of Slugs from a string. pgrx postgresql postgresql-extension rust slugify slugify Functions and aggregatesFunctions and aggregates · Extensions sm2ExtensionsExtensionsSM2 elliptic curve cryptography functions (Chinese National Standard GB/T 32918) sm2 SecuritySecurity · Extensions sm4ExtensionsExtensionsSM4 encryption/decryption functions (Chinese National Standard) sm4 SecuritySecurity · Extensions smlarExtensionsExtensionsEffective similarity search nil-lic smlar AI and vectorsAI and vectors · Extensions snowball_bilingualExtensionsExtensionssnowball_bilingual - add-on dictionary template using the combined results of two snowball stemmers elm graphql library-database media-server mediatum postgresql tum webapp snowball_bilingua…Full-text search · Extensions snowball_extExtensionsExtensionsExtensible Snowball text-search dictionary template with a Nepali stemmer. full-text-search nepali snowball stemming snowball_ext Full-text searchFull-text search · Extensions snowflakeExtensionsExtensionsSnowflake-style 64-bit ID generator and sequence utilities for PostgreSQL fork pgedge snowflake Functions and aggregatesFunctions and aggregates · Extensions softvisio_adminExtensionsExtensionsProprietary SQL administration extension for database/role provisioning and cluster-wide extension inventory and updates via dblink. cluster-admin database-provisioning dblink extension-upda…Administration · Extensions softvisio_typesExtensionsExtensionsPostgreSQL additional types extension softvisio_types Data typesData types · Extensions solverapiExtensionsExtensionsSolveDB: A PostgreSQL-based DBMS for optimization applications solverapi FeaturesFeatures · Extensions soundex-functionExtensionsExtensionssoundex - function for comparing strings example soundex template soundex-function Full-text searchFull-text search · Extensions soundex-typeExtensionsExtensionssoundex - type example soundex template soundex-type Full-text searchFull-text search · Extensions spanExtensionsExtensionsC data type for indexed document text spans, with casts, comparisons, B-tree/hash operator classes, aggregates, and accessors. document text-span pg_span Data typesData types · Extensions sparqlExtensionsExtensionsQuery SPARQL datasource with SQL supabase pgsparql UtilitiesUtilities · Extensions sparse_vectorExtensionsExtensionsC data type and functions for sparse float vectors, normalization, dot product, and cosine similarity. cosine-similarity data-type dot-product sparse-vector vector pg_sparse_vector AI and ve…AI and vectors · Extensions spatExtensionsExtensionsRedis-like In-Memory DB Embedded in Postgres spat CompatibilityCompatibility · Extensions spgistExtensionsPG1865.3. SP-GiST IndexesSP-GiST Indexes spgistExtensionsExtensionsSP-GIST index (access method) spgist FeaturesFeatures · Extensions sphinxExtensionsExtensionsC connector for querying and updating an external SphinxSearch server from PostgreSQL. connector external-search network sphinxsearch pg-sphinx Full-text searchFull-text search · Extensions sphinxlinkExtensionsExtensionsC extension for issuing SphinxSearch or ManticoreSearch queries from PostgreSQL through the MySQL-compatible protocol. manticore-search remote-search sphinx-search sphinxlink Full-text searc…Full-text search · Extensions spiExtensionsPG18F.41. spi — Server Programming Interface features/examples The spi module provides several workable examples of using the Server Programming Interface (SPI) and triggers. While these functio…spi — Server Programming Interface features/examples