Search PostgreSQL documentation

pg-audit-jsonExtensionsExtensionsSecurity · ExtensionsTrigger-based PostgreSQL table auditing with JSONB row snapshots and recursive change diffs. audit jsonb trigger pg-audit-json Security pg-gvmExtensionsExtensionsUtilities · ExtensionsFunctions for GVMd pg-gvm Utilities pg-jsonExtensionsExtensionsData types · ExtensionsA json data type and related functions pg-json Data types pg2podgExtensionsExtensionsFeatures · ExtensionsPostgreSQL extension for two-player open deterministic games. game pg2podg Features pg4mlExtensionsExtensionsAI and vectors · ExtensionsMachine learning framework for PostgreSQL pg4ml AI and vectors pg_aaExtensionsExtensionsFunctions and aggregates · ExtensionsASCII art extension for PostgreSQL pg_aa Functions and aggregates pg_abrisExtensionsExtensionsFeatures · ExtensionsAbris metadata extension that creates a meta schema with metadata tables, views, and helper functions. metadata pg_abris Features pg_acExtensionsExtensionsFull-text search · ExtensionsPostgreSQL extension for full text search aho-corasick full-text-search postgresql postgresql-extension sql pg_ac Full-text search pg_acceExtensionsExtensionsAnalytics · ExtensionsAccelerated Engine background-worker pg_acce Analytics pg_accumulatorExtensionsExtensionsFunctions and aggregates · ExtensionsAccumulation registers for balance and turnover tracking in PostgreSQL accounting finance ledger aggregation pg_accumulator Functions and aggregates pg_aclExtensionsExtensionsData types · ExtensionsUtilities for handling aclitems. acl aclitem grant permissions revoke pg_acl Data types pg_ad_mappingExtensionsExtensionsSecurity · ExtensionsMaps Active Directory security groups to database roles on Aurora PostgreSQL. pg_ad_mapping Security pg_addressExtensionsExtensionsData types · ExtensionsExtension creates composite type to store address address composite-type pg_address Data types pg_admExtensionsExtensionsAdministration · ExtensionsA PostgreSQL extension providing some administrative tools. bloat disk sizes maintenance management reports statistics pg_adm Administration pg_aggExtensionsExtensionsProcedural languages · ExtensionsExperimental aggregate-query support extension; its install script currently creates the untrusted PL/Python language. aggregate index plpython3u pg_agg Procedural languages pg_aggregateManual ChaptersPG18The catalog pg_aggregate stores information about aggregate functions. An aggregate function is a function that operates on a set of values (typically one column from each row that matches a… pg_aiExtensionsExtensionsAI and vectors · ExtensionsPostgreSQL extension that provides (RAG capable)SQL functions to interpret data using multi modal LLMs and vectors. pg_ai AI and vectors pg_ai_queryExtensionsExtensionsFeatures · ExtensionsAI-powered SQL query generation for PostgreSQL pg_ai_query Features pg_ai_sdkExtensionsExtensionsAI and vectors · ExtensionsTranslate natural language to SQL using Clickhouse ai-sdk-cpp pg_ai_sdk AI and vectors pg_ai_stewardsExtensionsExtensionsAI and vectors · ExtensionsPostgreSQL-backed agent state, work queues and model dispatch agents queues pgrx pg-ai-stewards AI and vectors pg_aiosManual ChaptersPG18The pg_aios view lists all Asynchronous I/O handles that are currently in-use. An I/O handle is used to reference an I/O operation that is being prepared, executed or is in the process of co… pg_algorandExtensionsExtensionsUtilities · ExtensionsAlgorand address, application, asset, transaction, and checksum encoding utilities. algorand encoding address blockchain pg_algorand Utilities pg_algorithmsExtensionsExtensionsFunctions and aggregates · ExtensionsC extension that adds example algorithm functions, including bubble sort and quicksort for integer arrays. algorithm sort pg_algorithms Functions and aggregates pg_amManual ChaptersPG18The catalog pg_am stores information about relation access methods. There is one row for each access method supported by the system. Currently, only tables and indexes have access methods. T… pg_amcheckCommand-line ToolsPG18checks for corruption in one or more PostgreSQL databases Synopsis pg_amcheck [option...] [dbname] pg_amcheckManual ChaptersPG18checks for corruption in one or more PostgreSQL databases Synopsis pg_amcheck [option...] [dbname] pg_amcheck --allCommand-line ToolsPG18pg_amcheck › Optionsa--all Check all databases, except for any excluded via --exclude-database. pg_amcheck --checkuniqueCommand-line ToolsPG18pg_amcheck › Optionscheckunique For each index with unique constraint checked, verify that no more than one among duplicate entries is visible in the index using amcheck's checkunique option. pg_amcheck --database=patternCommand-line ToolsPG18pg_amcheck › Optionsd pattern--database=pattern Check databases matching the specified pattern, except for any excluded by --exclude-database. This option can be specified more than once. pg_amcheck --echoCommand-line ToolsPG18pg_amcheck › Optionse--echo Echo to stdout all SQL sent to the server. pg_amcheck --endblock=blockCommand-line ToolsPG18pg_amcheck › Optionsendblock=block End checking at the specified block number. An error will occur if the table relation being checked has fewer than this number of blocks. This option does not apply to indexes… pg_amcheck --exclude-database=patternCommand-line ToolsPG18pg_amcheck › OptionsD pattern--exclude-database=pattern Exclude databases matching the given pattern. This option can be specified more than once. pg_amcheck --exclude-index=patternCommand-line ToolsPG18pg_amcheck › OptionsI pattern--exclude-index=pattern Exclude indexes matching the specified pattern. This option can be specified more than once. This is similar to the --exclude-relation option, except that it… pg_amcheck --exclude-relation=patternCommand-line ToolsPG18pg_amcheck › OptionsR pattern--exclude-relation=pattern Exclude relations matching the specified pattern. This option can be specified more than once. As with --relation, the pattern may be unqualified, schema-… pg_amcheck --exclude-schema=patternCommand-line ToolsPG18pg_amcheck › OptionsS pattern--exclude-schema=pattern Exclude tables and indexes in schemas matching the specified pattern. This option can be specified more than once. As with --schema, the pattern may be data… pg_amcheck --exclude-table=patternCommand-line ToolsPG18pg_amcheck › OptionsT pattern--exclude-table=pattern Exclude tables matching the specified pattern. This option can be specified more than once. This is similar to the --exclude-relation option, except that it … pg_amcheck --exclude-toast-pointersCommand-line ToolsPG18pg_amcheck › Optionsexclude-toast-pointers By default, whenever a toast pointer is encountered in a table, a lookup is performed to ensure that it references apparently-valid entries in the toast table. These c… pg_amcheck --heapallindexedCommand-line ToolsPG18pg_amcheck › Optionsheapallindexed For each index checked, verify the presence of all heap tuples as index tuples in the index using amcheck's heapallindexed option. pg_amcheck --helpCommand-line ToolsPG18pg_amcheck › Options?--help Show help about pg_amcheck command line arguments, and exit. pg_amcheck --host=hostnameCommand-line ToolsPG18pg_amcheck › Optionsh hostname--host=hostname Specifies the host name of the machine on which the server is running. If the value begins with a slash, it is used as the directory for the Unix domain socket.