Search PostgreSQL documentation

pg_treExtensionsExtensionsFull-text search · ExtensionsNative PostgreSQL index access method for approximate regular-expression matching approximate-matching edit-distance fuzzy-search index regex tre pg_tre Full-text search pg_trexExtensionsExtensionsAnalytics · Extensionspg trex: PostgreSQL extension for distributed trexsql pgrx rust pg_trex Analytics pg_trgmExtensionsPG18pg_trgm — support for similarity of text using trigram matchingsupport for similarity of text using trigram matching The pg_trgm module provides functions and operators for determining the similarity of alphanumeric text based on trigram matching, as we… pg_trgm — support for similarity of text using trigram matchingManual ChaptersPG18The pg_trgm module provides functions and operators for determining the similarity of alphanumeric text based on trigram matching, as well as index operator classes that support fast searchi… pg_trgm.similarity_thresholdGUC ParametersPG18pg_trgm — support for similarity of text using trigram matching › GUC Parameters(real) Sets the current similarity threshold that is used by the % operator. The threshold must be between 0 and 1 (default is 0.3). pg_trgm.strict_word_similarity_thresholdGUC ParametersPG18pg_trgm — support for similarity of text using trigram matching › GUC Parameters(real) Sets the current strict word similarity threshold that is used by the <<% and %>> operators. The threshold must be between 0 and 1 (default is 0.5). pg_trgm.word_similarity_thresholdGUC ParametersPG18pg_trgm — support for similarity of text using trigram matching › GUC Parameters(real) Sets the current word similarity threshold that is used by the <% and %> operators. The threshold must be between 0 and 1 (default is 0.6). pg_trickleExtensionsExtensionsFeatures · ExtensionsStreaming tables and differential view maintenance for PostgreSQL 18 ivm streaming materialized-view cdc rust differential-dataflow pgrx pg_trickle Features pg_triggerManual ChaptersPG18The catalog pg_trigger stores triggers on tables and views. See CREATE TRIGGER for more information. Table 52.58. pg_trigger Columns Column Type Description oid oid Row identifier tgrelid oi… pg_ts_configManual ChaptersPG18The pg_ts_config catalog contains entries representing text search configurations. A configuration specifies a particular text search parser and a list of dictionaries to use for each of the… pg_ts_config_mapManual ChaptersPG18The pg_ts_config_map catalog contains entries showing which text search dictionaries should be consulted, and in what order, for each output token type of each text search configuration's pa… pg_ts_dictManual ChaptersPG18The pg_ts_dict catalog contains entries defining text search dictionaries. A dictionary depends on a text search template, which specifies all the implementation functions needed; the dictio… pg_ts_parserManual ChaptersPG18The pg_ts_parser catalog contains entries defining text search parsers. A parser is responsible for splitting input text into lexemes and assigning a token type to each lexeme. Since a parse… pg_ts_templateManual ChaptersPG18The pg_ts_template catalog contains entries defining text search templates. A template is the implementation skeleton for a class of text search dictionaries. Since a template must be implem… pg_tsparserExtensionsExtensionsFull-text search · ExtensionsParser for PostgreSQL text search full-text-search parser pg_tsparser Full-text search pg_ttl_indexExtensionsExtensionsFeatures · ExtensionsAutomatic data expiration with TTL indexes pg_ttl_index Features pg_turboquantExtensionsExtensionsAI and vectors · ExtensionsCompact TurboQuant approximate-nearest-neighbor index access method for pgvector vector and halfvec data. ann index pgvector turboquant vector pg_turboquant AI and vectors pg_turbovecExtensionsExtensionsAI and vectors · ExtensionsTurboQuant-compressed vector type and ANN index access method for PostgreSQL. ann pgrx quantization rust turboquant vector-search pg_turbovec AI and vectors pg_turretExtensionsExtensionsMonitoring · ExtensionsCapture PostgreSQL logs and export structured events to HTTP, Kafka, or Sentry http kafka logging observability pgrx sentry pg_turret Monitoring pg_tursoExtensionsExtensionsReplication and streams · ExtensionsPostgres output plugin for replicating data to Turso. postgresql-extension replication turso pg_turso Replication and streams pg_tviewsExtensionsExtensionsFeatures · ExtensionsTransactional materialized views with automatic incremental refresh for PostgreSQL pgrx pg_tviews Features pg_twkbExtensionsExtensionsGeospatial · ExtensionsTWKB tools etc geospatial postgis twkb pg_twkb Geospatial pg_txn_statusExtensionsExtensionsData types · ExtensionsOne-byte txn_status data type for storing transaction state values. pg_txn_status Data types pg_typeManual ChaptersPG18The catalog pg_type stores information about data types. Base types and enum types (scalar types) are created with CREATE TYPE, and domains with CREATE DOMAIN. A composite type is automatica… pg_typescriptExtensionsExtensionsProcedural languages · ExtensionsTypeScript/JavaScript procedural language for PostgreSQL deno javascript pgrx procedural-language typescript v8 pg_typescript Procedural languages pg_udpExtensionsExtensionsUtilities · ExtensionsSend UDP datagrams from a PostgreSQL function. networking udp pg_udp Utilities pg_ulidExtensionsExtensionsFunctions and aggregates · ExtensionsGenerate ULID strings in PostgreSQL with a C function. identifier ulid pg_ulid Functions and aggregates pg_uomExtensionsExtensionsFunctions and aggregates · ExtensionsUnit conversions with dimensional and affine checks. pgrx proof-of-concept pg_extensions Functions and aggregates pg_upgradeManual ChaptersPG18upgrade a PostgreSQL server instance Synopsis pg_upgrade -b oldbindir [-B newbindir] -d oldconfigdir -D newconfigdir [option...] pg_upgradeManual ChaptersPG18Release 18Allow pg_upgrade to preserve optimizer statistics (Corey Huinker, Jeff Davis, Nathan Bossart) § § § § Extended statistics are not preserved. Also add pg_upgrade option --no-statistics to dis… pg_uplessExtensionsExtensionsAdministration · ExtensionsDetect Useless UPDATE pg_upless Administration pg_urlExtensionsExtensionsFunctions and aggregates · ExtensionsImplements URL handling methods as postgres extension pgrx postgres postgresql postgresql-extension rust pg_url Functions and aggregates pg_userManual ChaptersPG18The view pg_user provides access to information about database users. This is simply a publicly readable view of pg_shadow that blanks out the password field. Table 53.35. pg_user Columns Co… pg_user_mappingManual ChaptersPG18The catalog pg_user_mapping stores the mappings from local user to remote. Access to this catalog is restricted from normal users, use the view pg_user_mappings instead. Table 52.66. pg_user… pg_user_mappingsManual ChaptersPG18The view pg_user_mappings provides access to information about user mappings. This is essentially a publicly readable view of pg_user_mapping that leaves out the options field if the user ha… pg_utility_trigger_functionsExtensionsExtensionsUtilities · ExtensionsSome pet trigger functions that the extension author likes to follow him through various PostgreSQL projects. function functions plpgsql postgres postgresql postgresql-extension trigger trig… pg_utl_smtpExtensionsExtensionsCompatibility · ExtensionsOracle UTL_SMTP compatibility extension for PostgreSQL pg_utl_smtp Compatibility pg_uuidExtensionsExtensionsFunctions and aggregates · Extensionsgenerator of new UUID versions pg_uuid Functions and aggregates pg_uuid_nextExtensionsExtensionsFunctions and aggregates · ExtensionsImplementation of UUID v7 and v8 IETF drafts pg_uuid_next Functions and aggregates pg_uuid_v8ExtensionsExtensionsFunctions and aggregates · ExtensionsUUID v8 generator with embedded timestamps for PostgreSQL pg_uuid_v8 Functions and aggregates