Search PostgreSQL documentation

pg_rewriteExtensionsExtensionsAdministration · ExtensionsTool allows read write to the table during the rewriting pg_rewrite Administration pg_rippleExtensionsExtensionsFeatures · ExtensionsProvides an RDF knowledge-graph engine with SPARQL, SHACL, Datalog reasoning, federation, and graph analytics inside PostgreSQL 18. knowledge-graph pgrx rdf sparql pg_ripple Features pg_riskExtensionsExtensionsFeatures · ExtensionsDeterministic risk policies with auditable decisions policy risk audit pg_risk Features pg_rlimitExtensionsExtensionsAdministration · Extensionssetrlimit/getrlimit functions memory resource-limits security pg_rlimit Administration pg_roastExtensionsExtensionsSecurity · ExtensionsOpinionated PostgreSQL database auditor pg_roast Security pg_role_fkey_trigger_functionsExtensionsExtensionsSecurity · ExtensionsA bunch of trigger functions to help establish and/or maintain referential integrity for columns that reference PostgreSQL ROLE NAMEs. foreign key function functions plpgsql postgres postgre… pg_rolesManual ChaptersPG18The view pg_roles provides access to information about database roles. This is simply a publicly readable view of pg_authid that blanks out the password field. Table 53.21. pg_roles Columns … pg_ros2ExtensionsExtensionsFeatures · ExtensionsROS 2 graph snapshots and topic subscriptions in PostgreSQL ros2 robotics notifications pg_ros2 Features pg_row_hashesExtensionsExtensionsFunctions and aggregates · ExtensionsComputes deterministic row fingerprints, checksums, and XOR aggregates with SeaHash and FarmHash variants. checksums hashing pgrx pg_row_hashes Functions and aggregates pg_rowalesceExtensionsExtensionsFunctions and aggregates · Extensionsrowalesce() is like coalesce(), but for rows and other composite types. coalesce function functions jsonb plpgsql postgres postgresql postgresql-extension table pg_rowalesce Functions and ag… pg_rrfExtensionsExtensionsAI and vectors · ExtensionsReciprocal rank fusion functions for hybrid search pgrx pg_rrf AI and vectors pg_rruleExtensionsExtensionsData types · ExtensionsRRULE field type for PostgreSQL pg_rrule Data types pg_rulesManual ChaptersPG18The view pg_rules provides access to useful information about query rewrite rules. Table 53.22. pg_rules Columns Column Type Description schemaname name (references pg_namespace.nspname) Nam… pg_running_statsExtensionsExtensionsFunctions and aggregates · ExtensionsMergeable Running Statistics (Welford/Chan) Extension for PostgreSQL aggregate c-programming chan-et-al custom-aggregate postgresql postgresql-extension running-statistics state-statistics w… pg_rusageExtensionsExtensionsMonitoring · ExtensionsGathering of template plugins for PostgreSQL: background workers, logical replication things, etc. pg_rusage Monitoring pg_rvbbitExtensionsExtensionsAI and vectors · ExtensionsSemantic SQL operators backed by configurable LLMs, with caching, receipts, and routing across multiple execution engines. pg_rvbbit AI and vectors pg_s2ExtensionsExtensionsGeospatial · ExtensionsAdds an S2 CellID type, hierarchy and covering functions, distance helpers, casts, operators, and a B-tree operator class. gis pgrx s2 spatial pg_s2 Geospatial pg_safer_settingsExtensionsExtensionsAdministration · ExtensionsFunctions and mechanisms for handling PostgreSQL settings more safely. domain function functions plpgsql postgres postgresql postgresql-extension semver settings type pg_safer_settings Admin… pg_safer_settings_table_dependent_extensionExtensionsExtensionsAdministration · ExtensionsA handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. postgres postgresql postgresql-extension pg_safer_settings_table_dependent_extension Administra… pg_safer_settings_table_dependent_subextensionExtensionsExtensionsAdministration · ExtensionsA handful of functions and mechanisms to make dealing with settings in Postgres a bit … safer. postgres postgresql postgresql-extension pg_safer_settings_table_dependent_subextension Adminis… pg_sag_ragExtensionsExtensionsAI and vectors · ExtensionsPure-SQL multi-hop event/entity retrieval, query routing, and in-database RAG evaluation. rag retrieval routing evaluation pg_sag_rag AI and vectors pg_sageExtensionsExtensionsAdministration · ExtensionsProvides a preload C DBA agent extension and a newer standalone Go monitoring and guarded-action sidecar. agentic database-administration mcp monitoring pg_sage Administration pg_sakila_dbExtensionsExtensionsFeatures · ExtensionsPostgreSQL extension for deploying a port of the Sakila example database. database postgres-extension sakila-db testing pg_sakila_db Features pg_sample_extExtensionsExtensionsFunctions and aggregates · ExtensionsA Sample PostgreSQL extension custom extension function postgresql sample pg_sample_ext Functions and aggregates pg_sampletologExtensionsExtensionsMonitoring · ExtensionsSamples statements or whole transactions into PostgreSQL logs through executor and utility hooks. logging observability sampling pg_sampletolog Monitoring pg_satsExtensionsExtensionsAdministration · ExtensionsPer-role query metering and optional enforcement using satoshi-denominated balances. metering bitcoin quota executor-hook pg_sats Administration pg_saviorExtensionsExtensionsAdministration · ExtensionsPostgres extension to save OOPS mistakes pg_savior Administration pg_scwsExtensionsExtensionsFull-text search · Extensionsa parser for full-text search of Chinese pg_scws Full-text search pg_sealExtensionsExtensionsSecurity · ExtensionsTamper-evident audit log for PostgreSQL 🦭 audit-log blake3 hash-chain logical-decoding pgrx postgres postgresql rust tamper-evident pg_seal Security pg_searchExtensionsExtensionsFull-text search · ExtensionsFull text search for PostgreSQL using BM25 paradedb search analytics bm25 full-text search hybrid search faceted search columnar olap pgrx pg_search Full-text search pg_seclabelManual ChaptersPG18The catalog pg_seclabel stores security labels on database objects. Security labels can be manipulated with the SECURITY LABEL command. For an easier way to view security labels, see Section… pg_seclabelsManual ChaptersPG18The view pg_seclabels provides information about security labels. It as an easier-to-query version of the pg_seclabel catalog. Table 53.23. pg_seclabels Columns Column Type Description objoi… pg_secretExtensionsExtensionsSecurity · ExtensionsDefines order-revealing encrypted domains, comparison operators, and a B-tree operator class. encryption order-revealing-encryption pg_secret Security pg_semantic_cacheExtensionsExtensionsAI and vectors · ExtensionsCaches query results and retrieves semantically similar results using pgvector embeddings and configurable eviction policies. rag semantic-cache vector-search pg_semantic_cache AI and vector… pg_semantiusExtensionsExtensionsFeatures · ExtensionsDatabase-first application backend with RBAC, RLS, data dictionary, and message queue. rbac rls backend queue pg_semantius Features pg_semverExtensionsExtensionsData types · ExtensionsVersion(SEMVER) data type for postgresql postgresql postgresql-data-type postgresql-extension pg_semver Data types pg_sendmailExtensionsExtensionsUtilities · ExtensionsSends email from SQL by invoking a sendmail-compatible executable at a fixed server path. email sendmail pg_sendmail Utilities pg_sentence_transformerExtensionsExtensionsAI and vectors · ExtensionsRuns a Hugging Face sentence-transformer model inside a preload background worker and maintains pgvector embeddings for a configured table. background-worker embeddings sentence-transformers… pg_sequenceManual ChaptersPG18The catalog pg_sequence contains information about sequences. Some of the information about sequences, such as the name and the schema, is in pg_class Table 52.47. pg_sequence Columns Column… pg_sequenceExtensionsExtensionsFunctions and aggregates · ExtensionsERP document numbering with formatted, scoped, auto-incrementing sequences pg_sequence Functions and aggregates