Search PostgreSQL documentation

ctidscanExtensionsExtensionsExample custom scan provider for CTID range predicates. custom-scan planner ctidscan FeaturesFeatures · Extensions cubeExtensionsPG18F.10. cube — a multi-dimensional cube data type This module implements a data type cube for representing multidimensional cubes. This module is considered “trusted”, that is, it can be insta…cube — a multi-dimensional cube data type currencyExtensionsExtensionsCustom PostgreSQL currency type in 1Byte pg_currency Data typesData types · Extensions custom_propertiesExtensionsExtensionsSupabase RLS helper tables and functions for managing user properties and custom claims. claims rls supabase custom_properties SecuritySecurity · Extensions custom_rolesExtensionsExtensionsRole-specific Supabase RLS tables and functions for managing user roles. rls roles supabase garyaustin-custom_roles SecuritySecurity · Extensions cyanauditExtensionsExtensionsCyan Audit core extension audit audit log audit logging audit trail auditing cyan audit cyanaudit dml log forensic logging forensics logger logging transaction history trigger-based logging …Security · Extensions dammExtensionsExtensionsSQL implementation of the Damm check digit algorithm with a damm_code domain and helper functions. check-digit damm-algorithm data-type damm Data typesData types · Extensions data2pgExtensionsExtensionsMigration framework for discovering, copying, and comparing non-PostgreSQL database content through foreign data wrappers. data2pg Replication and streamsReplication and streams · Extensions data_historizationExtensionsExtensionsPLPGSQL Script to historize data in partitionned table data_historization UtilitiesUtilities · Extensions data_rigExtensionsExtensionsMultidimensional OLAP fact data type with GiST indexing support. data-type gist olap data_rig AnalyticsAnalytics · Extensions dataclipsExtensionsExtensionsArchived, unfinished C prototype for querying Heroku Dataclips through a function and planned FDW. dataclips fdw heroku http dataclips Foreign data wrappersForeign data wrappers · Extensions datafly_anonExtensionsExtensionsDatafly anonymizer anonymization gdpr datafly_anon SecuritySecurity · Extensions datalinkExtensionsExtensionsSQL/MED DATALINK data type and functions for controlled access to files outside PostgreSQL background-worker data-type file datalink Data typesData types · Extensions datasketchesExtensionsExtensionsApproximate analytics sketches and aggregates for PostgreSQL datasketches Functions and aggregatesFunctions and aggregates · Extensions date_string_converterExtensionsExtensionspgrx extension skeleton for date-string conversion; current source exposes hello_date_string_converter(). pgrx date_string_converter Time seriesTime series · Extensions daterangexExtensionsExtensionsDate range type whose displayed upper bound is inclusive, with casts and operators. date range inclusive btree daterangex Data typesData types · Extensions db2_fdwExtensionsExtensionsforeign data wrapper for DB2 access non-free db2_fdw Foreign data wrappersForeign data wrappers · Extensions db2fceExtensionsExtensionsDB2 compatibility functions, types, operators, and SYSIBM.SYSDUMMY1 for PostgreSQL. db2fce CompatibilityCompatibility · Extensions db2odbc_fdwExtensionsExtensionsForeign data wrapper for accessing IBM Db2 through an ODBC data source db2 fdw odbc db2odbc_fdw Foreign data wrappersForeign data wrappers · Extensions db721_fdwExtensionsExtensionsRust/pgrx foreign data wrapper for db721 files, developed for CMU 15-721 project data. db721 fdw file-format pgrx rust db721_fdw Foreign data wrappersForeign data wrappers · Extensions db_assistExtensionsExtensionsMinimal pgrx training extension exposing a hello_db_assist function. db_assist Functions and aggregatesFunctions and aggregates · Extensions db_infoExtensionsExtensionsFunctions and views reporting database size, ownership, tablespaces, extensions, and object counts. database-metadata monitoring db_info MonitoringMonitoring · Extensions db_migratorExtensionsExtensionsTools to migrate other databases to PostgreSQL db_migrator Replication and streamsReplication and streams · Extensions dbdevExtensionsExtensionsIn-database client for installing packages from the database.dev registry. dbdev package-manager tle dbdev AdministrationAdministration · Extensions dblinkExtensionsPG18F.11. dblink — connect to other PostgreSQL databases dblink is a module that supports connections to other PostgreSQL databases from within a database session. dblink can report the followin…dblink — connect to other PostgreSQL databases dblink_plusExtensionsExtensionsRun SQL against external PostgreSQL, Oracle, MySQL, and SQLite databases from PostgreSQL. dblink mysql oracle sqlite dblink_plus Foreign data wrappersForeign data wrappers · Extensions dbms_jobExtensionsExtensionsEPAS Oracle-compatible DBMS_JOB package backed by EDB Job Scheduler. oracle scheduler jobs compatibility edb_job_scheduler Time seriesTime series · Extensions dbms_schedulerExtensionsExtensionsEPAS Oracle-compatible DBMS_SCHEDULER programs, schedules, and jobs. oracle scheduler jobs compatibility edb_job_scheduler Time seriesTime series · Extensions dbms_sqlExtensionsExtensionsImplements a subset of Oracle's DBMS_SQL package API to ease application migration to PostgreSQL. dbms-sql migration oracle-compatibility dbms_sql CompatibilityCompatibility · Extensions dbpatchExtensionsExtensionsPostgreSQL database patch change management extension change database deploying management patch dbpatch AdministrationAdministration · Extensions dbstatExtensionsExtensionsCollects exact table row counts and modification timing through SQL objects and a companion libpq process. monitoring statistics dbstat MonitoringMonitoring · Extensions dbstatsExtensionsExtensionsDescriptive statistics and data quality analysis for PostgreSQL dbstats Functions and aggregatesFunctions and aggregates · Extensions dbt2ExtensionsExtensionsOSDL-DBT-2 test kit test dbt2 Procedural languagesProcedural languages · Extensions dbtune_mabExtensionsExtensionsDBTune MAB advisor for PostgreSQL dbtune_mab FeaturesFeatures · Extensions dc_fdwExtensionsExtensionsHistorical foreign data wrapper for document collections stored on local disk. fdw document filesystem collection dc_fdw Foreign data wrappersForeign data wrappers · Extensions ddl_historizationExtensionsExtensionsHistorize the ddl changes inside PostgreSQL database ddl_historization UtilitiesUtilities · Extensions ddl_replExtensionsExtensionsReplicate DDL and DCL commands across PostgreSQL instances by means of a utility hook ddl hook replication pg_repl Replication and streamsReplication and streams · Extensions ddl_versioningExtensionsExtensionsDDL object versioning with event triggers for tables, indexes, functions, and views. ddl event-trigger versioning ddl_versioning AdministrationAdministration · Extensions ddlaExtensionsExtensionsAudit DDL changes with event triggers and queryable log functions audit ddl event-trigger ddla SecuritySecurity · Extensions ddlxExtensionsExtensionsDDL eXtractor functions pgdg-flaw pg_ddlx AdministrationAdministration · Extensions