Search PostgreSQL documentation

pg_multitenantExtensionsExtensionsSecurity · ExtensionsMulti-tenant shared-schema helpers using PostgreSQL row-level security multitenancy pgrx row-level-security shared-schema pg_multitenant Security pg_mupdfExtensionsExtensionsUtilities · ExtensionsConvert HTML to PDF inside PostgreSQL using MuPDF html pdf pg_mupdf Utilities pg_mustachExtensionsExtensionsUtilities · ExtensionsPostgreSQL implementation of Mustache templating mustach template pg_mustach Utilities pg_mysqlExtensionsExtensionsCompatibility · ExtensionsA PostgreSQL extension for launching MySQL servers from within PostgreSQL pg_mysql Compatibility pg_mystemExtensionsExtensionsFull-text search · ExtensionsRuns Yandex Mystem worker processes to provide Russian-language lemmatization from PostgreSQL queries. fts morphology nlp pg_mystem Full-text search pg_namespaceManual ChaptersPG18The catalog pg_namespace stores namespaces. A namespace is the structure underlying SQL schemas: each namespace can have a separate collection of relations, types, etc. without name conflict… pg_nanoidExtensionsExtensionsData types · ExtensionsPostgreSQL extension adding a NanoID type and NanoID generation functions. identifier nanoid pgrx type pg_nanoid Data types pg_nanpExtensionsExtensionsData types · ExtensionsValidated and consistently formatted North American Numbering Plan data type phone-number type validation pg_nanp Data types pg_natural_sort_orderExtensionsExtensionsFunctions and aggregates · ExtensionsNatural sort ordering support through a C normalization function usable with indexes. index natural-sort sort pg_natural_sort_order Functions and aggregates pg_neon_sudoExtensionsExtensionsSecurity · ExtensionsProvides Neon-specific trusted sudo wrappers that run PostgreSQL Anonymizer dynamic-masking start and stop operations as the bootstrap superuser. neon security pg_neon_sudo Security pg_netExtensionsExtensionsUtilities · ExtensionsAsync HTTP Requests supabase pg_net Utilities pg_netstatExtensionsExtensionsMonitoring · Extensionspg netstat: network traffic monitor extensions pcap pgrx postgresql rust pg_netstat Monitoring pg_niceExtensionsExtensionsAdministration · ExtensionsLower the I/O scheduling priority of the current PostgreSQL backend with Linux ionice ionice linux process-priority pg_nice Administration pg_no_seqscanExtensionsExtensionsFeatures · ExtensionsPrevents or reports sequential scans in development and CI by inspecting query plans. ci development pgrx query-plan sequential-scan pg_no_seqscan Features pg_normalize_emailExtensionsExtensionsFunctions and aggregates · ExtensionsNormalize email addresses in PostgreSQL email normalization pg_normalize_email Functions and aggregates pg_normalize_queryExtensionsExtensionsFunctions and aggregates · ExtensionsNormalize constants in SQL statements using PostgreSQL parser logic query-normalization sql statistics pg_normalize_query Functions and aggregates pg_notifyManual ChaptersPG18NOTIFYTo send a notification you can also use the function pg_notify(text, text). The function takes the channel name as the first argument and the payload as the second. The function is much easi… pg_nowhereExtensionsExtensionsAdministration · ExtensionsA PostgreSQL extension to disallow UPDATE and DELETE queries without a WHERE clause. postgresql postgresql-extension pg_nowhere Administration pg_num2int_direct_compExtensionsExtensionsFunctions and aggregates · ExtensionsExact numeric/float-to-integer comparison operators that preserve index use. numeric integer operator index pg_num2int_direct_comp Functions and aggregates pg_ocpmExtensionsExtensionsAnalytics · ExtensionsObject-centric process-mining storage, traversal, aggregation, and compact analytical capsules. process-mining ocel graph analytics pg_ocpm Analytics pg_ocrExtensionsExtensionsAI and vectors · ExtensionsSelf-contained OCR functions via PL/Python pg_ocr AI and vectors pg_octopusExtensionsExtensionsMonitoring · ExtensionsRuns a background worker that periodically connects to configured PostgreSQL nodes and records their health status. cluster pg_octopus Monitoring pg_oidc_validatorExtensionsExtensionsSecurity · ExtensionsOAuth and OIDC token validator for PostgreSQL 18 pg_oidc_validator Security pg_oltp_benchExtensionsExtensionsFeatures · ExtensionsHelper function and pgbench scripts for a sysbench-style OLTP benchmark. benchmark oltp pgbench sysbench pg_oltp_bench Features pg_onceExtensionsExtensionsFeatures · ExtensionsRun‑once / idempotency‑key manager with TTL and response caching idempotency response-cache ttl pg_once Features pg_onnxExtensionsExtensionsAI and vectors · ExtensionsONNX Runtime integrated with PostgreSQL. Perform ML inference with data in your database. inference machine-learning onnx pg_onnx AI and vectors pg_opclassManual ChaptersPG18The catalog pg_opclass defines index access method operator classes. Each operator class defines semantics for index columns of a particular data type and a particular index access method. A… pg_open_meteoExtensionsExtensionsFunctions and aggregates · ExtensionsPrototype Rust/pgrx PostgreSQL extension associated with Open-Meteo weather data. open-meteo pgrx prototype weather pg_open_meteo Functions and aggregates pg_openccExtensionsExtensionsUtilities · ExtensionsConverts text among Simplified Chinese, Traditional Chinese regional variants and Japanese Shinjitai using OpenCC. nlp pg_opencc Utilities pg_opendalExtensionsExtensionsUtilities · ExtensionsAccess storage backends through Apache OpenDAL from PostgreSQL functions. object-storage opendal pgrx pg_opendal Utilities pg_operatorManual ChaptersPG18The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information. Table 52.34. pg_operator Columns Column Type Description oid oid Row i… pg_opfamilyManual ChaptersPG18The catalog pg_opfamily defines operator families. Each operator family is a collection of operators and associated support routines that implement the semantics specified for a particular i… pg_optigraphExtensionsExtensionsAI and vectors · Extensionspg Optigraph is a PostgreSQL extension which uses OptiGraph ML model. pg_optigraph AI and vectors pg_orcaExtensionsExtensionsAnalytics · ExtensionsORCA query optimizer as a PostgreSQL extension pg_orca Analytics pg_orphanedExtensionsExtensionsAdministration · ExtensionsDeal with orphaned files pg_orphaned Administration pg_ortoolsExtensionsExtensionsFunctions and aggregates · ExtensionsConstraint optimization extension using the HiGHS MIP/LP solver from PostgreSQL, with optional async execution. highs optimization pgrx solver pg_ortools Functions and aggregates pg_osExtensionsExtensionsFeatures · ExtensionsPostgreSQL extension providing operating system-level functionality directly through SQL, enabling process management, file system operations, IPC, and system monitoring within the database … pg_osgrExtensionsExtensionsGeospatial · ExtensionsOrdnance Survey grid reference handling for biological recording pg_osgr Geospatial pg_otel_tracerExtensionsExtensionsMonitoring · ExtensionsRust based Postgres extension that adds query lifecycle events to OTEL traces. database jaeger monitoring observability opentelemetry postgresql postgresql-extension rust tracing pg_otel_tra… pg_outriderExtensionsExtensionsAdministration · ExtensionsDynamically launches a background worker that extends a relation when its free-space watermark is crossed. pg_outrider Administration