Search PostgreSQL documentation

pg_grammar_guardExtensionsExtensionsAI and vectors · ExtensionsCatalog-derived grammars and approved grammar drift checks grammar llm catalog pg_grammar_guard AI and vectors pg_graphqlExtensionsExtensionsFeatures · ExtensionsAdd in-database GraphQL support pgrx supabase pg_graphql Features pg_graphql_serverExtensionsExtensionsFeatures · ExtensionsRuns an HTTP GraphQL endpoint from a PostgreSQL background worker and delegates queries to pg_graphql. pgrx pg_graphql_server Features pg_grexExtensionsExtensionsUtilities · ExtensionsA dynamic regex builder for PgSQL pgrx pgsql regex pg_grex Utilities pg_groupManual ChaptersPG18The view pg_group exists for backwards compatibility: it emulates a catalog that existed in PostgreSQL before version 8.1. It shows the names and members of all roles that are marked as not … pg_grpcExtensionsExtensionsUtilities · ExtensionsPostgreSQL gRPC grpc rpc pg_grpc Utilities pg_gslExtensionsExtensionsFunctions and aggregates · ExtensionsWraps selected GNU Scientific Library routines, including real FFT transforms and helper functions, for PostgreSQL. analytics fft pg_gsl Functions and aggregates pg_handlebarsExtensionsExtensionsUtilities · ExtensionsPostgreSQL handlebars handlebars template pg_handlebars Utilities pg_hardstorageExtensionsExtensionsAdministration · ExtensionsSQL views and writer functions for pg_hardstorage backup state backup monitoring pg_hardstorage Administration pg_hashidsExtensionsExtensionsFunctions and aggregates · ExtensionsShort unique id generator for PostgreSQL, using hashids pg_hashids Functions and aggregates pg_hba_file_rulesManual ChaptersPG18The view pg_hba_file_rules provides a summary of the contents of the client authentication configuration file, pg_hba.conf. A row appears in this view for each non-empty, non-comment line in… pg_headerkitExtensionsExtensionsUtilities · ExtensionsPostgreSQL SQL functions for reading PostgREST request headers inside database code headers postgrest supabase pg_headerkit Utilities pg_healerExtensionsExtensionsAdministration · ExtensionsProof-of-concept extension for automatically repairing PostgreSQL data corruption corruption recovery pg_healer Administration pg_healpixExtensionsExtensionsGeospatial · ExtensionsProvides PostgreSQL functions that convert sky coordinates to and from HEALPix nested and ring pixel identifiers. pg_healpix Geospatial pg_helloExtensionsExtensionsFeatures · ExtensionsPostgres "Hello world" extension pg_hello Features pg_hint_planExtensionsExtensionsFeatures · ExtensionsGive PostgreSQL ability to manually force some decisions in execution plans. pg_hint_plan Features pg_histExtensionsExtensionsFunctions and aggregates · ExtensionsCompute fast weighted or unweighted histograms in one or more dimensions. histogram statistics pg_hist Functions and aggregates pg_hlcExtensionsExtensionsData types · ExtensionsPostgreSQL HLC (Hybrid Logical Clock) extension in Rust compatible with Dart CRDT library. pg_hlc Data types pg_hspellExtensionsExtensionsFull-text search · ExtensionsFull text search dictionary template for Hebrew text using libhspell dictionary fts hebrew pg_hspell Full-text search pg_html5_email_addressExtensionsExtensionsUtilities · ExtensionsPostgreSQL email validation that is consistent with the HTML5 spec pg_html5_email_address Utilities pg_htmldocExtensionsExtensionsUtilities · ExtensionsConverts HTML, Markdown, files or web pages to PDF, PostScript and other HTMLDOC output formats from PostgreSQL. pg_htmldoc Utilities pg_httpsExtensionsExtensionsUtilities · ExtensionsHTTP/HTTPS client functions for PostgreSQL using libcurl curl http https pg_https Utilities pg_hybridExtensionsExtensionsAI and vectors · Extensionshybrid storage engine: columnar, vector, fulltext columar fulltext lance postgresql-database postgresql-extension storage-engine vector pg_hybrid AI and vectors pg_ibanExtensionsExtensionsData types · ExtensionsPostgreSQL extension providing IBAN (International Bank Account Number) data type and validation functions postgresql-extension pg_iban Data types pg_ibc_0_1ExtensionsExtensionsUtilities · ExtensionsPostgreSQL extension for decoding and handling IBC protocol data types blockchain ibc pgrx pg_ibc_0_1 Utilities pg_icalExtensionsExtensionsTime series · ExtensionsRRULE recurrence functions for PostgreSQL backed by libical calendar libical rrule pg_ical Time series pg_iceberg_amExtensionsExtensionsAnalytics · ExtensionsIceberg table developed by Robert Mu iceberg lakebase lakehouse postgresql postgresql-extension pg_iceberg_am Analytics pg_icu_parserExtensionsExtensionsFull-text search · ExtensionsFull text search parser using ICU boundary analysis fts icu pg_icu_parser Full-text search pg_ident_file_mappingsManual ChaptersPG18The view pg_ident_file_mappings provides a summary of the contents of the client user name mapping configuration file, pg_ident.conf. A row appears in this view for each non-empty, non-comme… pg_idkitExtensionsExtensionsFunctions and aggregates · Extensionsmulti-tool for generating new/niche universally unique identifiers (ex. UUIDv6, ULID, KSUID) pgrx pg_idkit Functions and aggregates pg_idmExtensionsExtensionsSecurity · ExtensionsExposes PostgreSQL role and membership management through updatable views and DML-trigger functions. pg_idm Security pg_idnaExtensionsExtensionsUtilities · ExtensionsWHATWG URL IDNA helpers for PostgreSQL idna internationalization pgrx pg_idna Utilities pg_idx_advisorExtensionsExtensionsFeatures · ExtensionsPostgreSQL index advisor advisor index performance query-tuning tuning pg_idx_advisor Features pg_igraphExtensionsExtensionsFeatures · ExtensionsHigh-performance graph traversal engine with JSON parameters and multi-graph support analytics bfs c extension cypher dynamic queries fast graph json parameters library integration multi-gra… pg_imageExtensionsExtensionsFunctions and aggregates · ExtensionsImage metadata, transforms, perceptual hashes and optional ONNX inference. pgrx proof-of-concept pg_extensions Functions and aggregates pg_imputed_genotypeExtensionsExtensionsData types · ExtensionsStore imputed-genotype probability triples in a packed four-byte PostgreSQL type. genomics probability type pg_imputed_genotype Data types pg_incrementalExtensionsExtensionsFeatures · ExtensionsIncremental Processing by Crunchy Data pg_incremental Features pg_indexManual ChaptersPG18The catalog pg_index contains part of the information about indexes. The rest is mostly in pg_class. Table 52.26. pg_index Columns Column Type Description indexrelid oid (references pg_class… pg_index_statsExtensionsExtensionsAdministration · ExtensionsCreate extended statistics on an index manually or automatically pg_index_stats Administration pg_indexesManual ChaptersPG18The view pg_indexes provides access to useful information about each index in the database. Table 53.12. pg_indexes Columns Column Type Description schemaname name (references pg_namespace.n…