Search PostgreSQL documentation

gb18030_2022ExtensionsExtensionsSupport GB18030-2022 and UTF-8 conversion fork ivory ivorysql CompatibilityCompatibility · Extensions gbdchecksExtensionsExtensionsDatabase health-check functions and views for bloat, locks, query statistics, and privileges. bloat monitoring permissions statistics gbdchecks AdministrationAdministration · Extensions gbuilderExtensionsExtensionsAdditional geometry builders gbuilder GeospatialGeospatial · Extensions gcdExtensionsExtensionsC function that computes the greatest common divisor of an integer array. greatest-common-divisor integer-array math gcd Functions and aggregatesFunctions and aggregates · Extensions gdpr_anatomizerExtensionsExtensionsPrototype GDPR/anatomy anonymization extension implemented with PL/Python and PL/pgSQL helpers. postgresql_anatomy SecuritySecurity · Extensions geekspeakExtensionsExtensionsDatabase schema extension for the GeekSpeak podcast website. podcast schema website pg_geekspeak FeaturesFeatures · Extensions geekspeak_calendarExtensionsExtensionsCalendar and iCalendar integration for GeekSpeak podcast recording schedules and episodes. calendar ical podcast scheduling pg_geekspeak_calendar Time seriesTime series · Extensions generate_date_seriesExtensionsExtensionsgenerate_series()-style set-returning function for date ranges with integer day steps. date generate-series set-returning-function generate_date_series Functions and aggregatesFunctions and aggregates · Extensions generate_up_down_seriesExtensionsExtensionsPostgreSQL Up Down Sequence c postgresql postgresql-extension series series-generator generate_up_down_series Functions and aggregatesFunctions and aggregates · Extensions generic_planExtensionsExtensionsGenerate a generic plan for a parameterized SQL statement. explain performance query-plan generic_plan MonitoringMonitoring · Extensions geohash_extraExtensionsExtensionsAdditional geohash functions geohash-extra GeospatialGeospatial · Extensions geohistorical_objectsExtensionsExtensionsGeohistorical objects support geohistorical_objects GeospatialGeospatial · Extensions geoipExtensionsExtensionsIP-based geolocation query pgdg-flaw geoip GeospatialGeospatial · Extensions geoip2lookupExtensionsExtensionsLook up IP-address info in MaxMind GeoIP2 MMDB files geolocation maxmind mmdb plperlu geoip2lookup GeospatialGeospatial · Extensions geqo_extensionExtensionsExtensionsLoad-only extraction of PostgreSQL's Genetic Query Optimizer with a planner hook and configurable GEQO behavior. genetic-algorithm join-order optimizer planner-hook geqo FeaturesFeatures · Extensions get_columnExtensionsExtensionsFetch a column value from a record by name column dynamic extension record row utility get_column Functions and aggregatesFunctions and aggregates · Extensions get_sumExtensionsExtensionssimple sum of two integers for postgres externsion using c get_sum Functions and aggregatesFunctions and aggregates · Extensions gevelExtensionsExtensionsIndex-inspection functions for GiST, GIN, SP-GiST, B-tree, and BRIN indexes. brin btree gin gist index-inspection sp-gist gevel AdministrationAdministration · Extensions gfsExtensionsExtensionsGFS copy-on-read storage: a Table Access Method whose missing rows are fetched from the source on read and written through locally agentic-ai agents clickhouse database mcp mysql postgresql …Replication and streams · Extensions gg_tables_trackingExtensionsExtensionsGreengage relation-size change tracking for monitoring and maintenance. greengage relation-size tracking monitoring greengage MonitoringMonitoring · Extensions gg_wait_samplingExtensionsExtensionsGreengage wait-event sampling with history and query attribution. greengage wait-event sampling monitoring greengage MonitoringMonitoring · Extensions ginExtensionsPG1865.4. GIN IndexesGIN Indexes gis_objectsExtensionsExtensionsPostgres extension for Point, Polygon, and Point-in-Polygon operations in C c gis postgresql-extension sql gis_objects GeospatialGeospatial · Extensions gistExtensionsPG1865.2. GiST IndexesGiST Indexes git_fdwExtensionsExtensionsPostgreSQL Git Foreign Data Wrapper fdw git git_fdw Foreign data wrappersForeign data wrappers · Extensions gitgresExtensionsExtensionsStore Git objects and refs in PostgreSQL tables with SQL functions and a native git_oid type. git libgit2 object-storage version-control gitgres FeaturesFeatures · Extensions gliaExtensionsExtensionsA PostgreSQL extension for data mining. analytics data data-mining mining glia AI and vectorsAI and vectors · Extensions gms_rawExtensionsExtensionsprocess raw type data for PL/SQL applications gms_raw CompatibilityCompatibility · Extensions gms_tcpExtensionsExtensionsprovides TCP/IP client=side access functionality in PL/SQL gms_tcp CompatibilityCompatibility · Extensions go_fdwExtensionsExtensionsExperimental Go/cgo project template for building PostgreSQL foreign data wrappers. cgo fdw go template go_fdw Foreign data wrappersForeign data wrappers · Extensions godel_logicExtensionsExtensionsProvides operators to evaluate fuzzy logic expressions according to Gödel logic. fuzzy gödel logic operators product łukasiewicz fuzzy_logic Functions and aggregatesFunctions and aggregates · Extensions gofdwExtensionsExtensionsPostgres FDW in go experiments gofdw Foreign data wrappersForeign data wrappers · Extensions gogudbExtensionsExtensionsPostgreSQL extension for distributed hash and range partitioning across foreign servers. distributed-database fdw partitioning sharding gogudb AnalyticsAnalytics · Extensions goldenmatch_pgExtensionsExtensionsGoldenMatch entity-resolution functions for deduplication, matching, scoring, and golden-record workflows. deduplication entity-resolution matching pgrx goldenmatch_pg AI and vectorsAI and vectors · Extensions google_columnar_engineExtensionsExtensionsAlloyDB column store, planner, and execution engine for accelerating HTAP and OLAP scans, joins, and aggregates. alloydb columnar htap olap query-acceleration google_columnar_engine Analytic…Analytics · Extensions google_db_advisorExtensionsExtensionsAlloyDB index advisor extension for workload analysis and index recommendations. alloydb index-advisor performance google_db_advisor FeaturesFeatures · Extensions google_ml_integrationExtensionsExtensionsGoogle Cloud machine learning integration extension for registering model endpoints, generating embeddings, and invoking predictions from SQL. ai embeddings machine-learning model-endpoint r…AI and vectors · Extensions google_plan_managementExtensionsExtensionsPreview AlloyDB extension for tracking, approving, denying, and consistently selecting query plans. alloydb plan-stability preview query-optimizer query-plans google_plan_management Administ…Administration · Extensions gp_debug_numsegmentsExtensionsExtensionsGet or set the default number of segments used when creating tables. big-data data-analysis data-warehouse database distributed-database greenplum mpp olap open-source postgresql gp_debug_nu…Administration · Extensions gp_distribution_policyExtensionsExtensionsCheck table distribution policy in a Greenplum-family cluster. gp_distribution_policy AdministrationAdministration · Extensions