Search PostgreSQL documentation

mansueli-function_vcExtensionsExtensionsAdministration · ExtensionsIn database version control for postgres functions database.dev tle mansueli-function_vc Administration mapcodeExtensionsExtensionsGeospatial · ExtensionsMapcodes in PostgreSQL geospatial latitude location longitude mapcode mapcode-postgres Geospatial Mapping Tables to XMLManual ChaptersPG18XML FunctionsThe following functions map the contents of relational tables to XML values. They can be thought of as XML export functionality: table_to_xml ( table regclass, nulls boolean, tableforest boo… Mappings between SQL and XML Data Types and ValuesManual ChaptersPG18XML Limits and Conformance to SQL/XMLIn SQL:2006 and later, both directions of conversion between standard SQL data types and the XML Schema types are specified precisely. However, the rules are expressed using the types and se… martindonadieu-supabase_auth_adminExtensionsExtensionsSecurity · ExtensionsSupabase Auth tool to check if a user is an platform admin database.dev tle martindonadieu-supabase_auth_admin Security mastermobilitydbExtensionsExtensionsGeospatial · ExtensionsSchema, types, and utilities for managing moving-object trajectories with MobilityDB. mastermobilitydb Geospatial Materialized ViewsManual ChaptersPG18in PostgreSQL use the rule system like views do, but persist the results in a table-like form. The main differences between: CREATE MATERIALIZED VIEW mymatview AS SELECT * FROM mytab; and: C… Mathematical Functions and OperatorsManual ChaptersPG18Mathematical operators are provided for many PostgreSQL types. For types without standard mathematical conventions (e.g., date/time types) we describe the actual behavior in subsequent secti… mbusExtensionsExtensionsFeatures · Extensionssimple message bus for pg mbus Features mcp_postgrestExtensionsExtensionsAI and vectors · ExtensionsPostgreSQL extension to define AI tools compatible with Anthropic's Model Context Protocol (MCP). Fully customizable, schema-agnostic, secure, and integrated with PostgREST. ai mcp model-con… MCV ListsManual ChaptersPG18Multivariate Statistics ExamplesAs explained in Section 69.2.1, functional dependencies are very cheap and efficient type of statistics, but their main limitation is their global nature (only tracking dependencies at the c… md5hashExtensionsExtensionsData types · Extensionstype for storing 128-bit binary data inline md5hash Data types mdbqsExtensionsExtensionsCompatibility · ExtensionsMongoDB-style query support for PostgreSQL jsonb mongodb query-language mdbqt Compatibility meanExtensionsExtensionsFunctions and aggregates · Extensionsaggregates and functions for PostgreSQL Server aggregates c custom-aggregates extension functions postgresql postgresql-extension mean Functions and aggregates Measuring Executor Timing OverheadManual ChaptersPG18pg_test_timingWhen the query executor is running a statement using EXPLAIN ANALYZE, individual operations are timed as well as showing a summary. The overhead of your system can be checked by counting row… MechanicsManual ChaptersPG18For the ProgrammerThis section describes how to implement native language support in a program or library that is part of the PostgreSQL distribution. Currently, it only applies to C programs. Adding NLS Supp… media_typesExtensionsExtensionsData types · ExtensionsStrongly typed MIME media-type data type for PostgreSQL media-type mime pgrx emi_monorepo Data types medianExtensionsExtensionsFunctions and aggregates · Extensionsaggregate function for input sets aggregate median statistics median Functions and aggregates medicationsExtensionsExtensionsFeatures · Extensionsextension dependency-closure medications source-only sql medications Features memleak_analyzerExtensionsExtensionsMonitoring · ExtensionsA PostgreSQL extension designed to analyze and localize logical memory leaks inside PostgreSQL backend sessions and background workers. memleak_analyzer Monitoring MemoryManual ChaptersPG18Resource Consumptionshared_buffers (integer) Sets the amount of memory the database server uses for shared memory buffers. The default is typically 128 megabytes (128MB), but might be less if your kernel settin… Memory ManagementManual ChaptersPG18PostgreSQL allocates memory within memory contexts, which provide a convenient method of managing allocations made in many different places that need to live for differing amounts of time. D… memoryamExtensionsExtensionsFeatures · ExtensionsIn-memory TableAM implementation memory tableam temporary memoryam Features memstatExtensionsExtensionsMonitoring · ExtensionsMemory context statistics for local and instance backends memory monitoring statistics memstat Monitoring memvolExtensionsExtensionsFunctions and aggregates · ExtensionsMemory units memvol Functions and aggregates MERGEManual ChaptersPG18conditionally insert, update, or delete rows of a table Synopsis [ WITH with_query [, ...] ] MERGE INTO [ ONLY ] target_table_name [ * ] [ [ AS ] target_alias ] USING data_source ON join_con… Merge Support FunctionsManual ChaptersPG18PostgreSQL includes one merge support function that may be used in the RETURNING list of a MERGE command to identify the action taken for each row; see Table 9.68. Table 9.68. Merge Support … merge_ipsExtensionsExtensionsFunctions and aggregates · ExtensionsFunctions to merge IP addresses, ignoring gaps cidr inet network merge_ips Functions and aggregates MERGESManual ChaptersPG18Operator Optimization InformationThe MERGES clause, if present, tells the system that it is permissible to use the merge-join method for a join based on this operator. MERGES only makes sense for a binary operator that retu… meson Build TargetsManual ChaptersPG18Building and Installation with MesonIndividual build targets can be built using ninja target. When no target is specified, everything except documentation is built. Individual build products can be built using the path/filenam… meson setup OptionsManual ChaptersPG18Building and Installation with Mesonmeson setup's command-line options are explained below. This list is not exhaustive (use meson configure --help to get one that is). The options not covered here are meant for advanced use-c… Message Data TypesManual ChaptersPG18This section describes the base data types used in messages. Intn(i) An n-bit integer in network byte order (most significant byte first). If i is specified it is the exact value that will a… Message FlowManual ChaptersPG18This section describes the message flow and the semantics of each message type. (Details of the exact representation of each message appear in Section 54.7.) There are several different sub-… Message FormatsManual ChaptersPG18This section describes the detailed format of each message. Each is marked to indicate that it can be sent by a frontend (F), a backend (B), or both (F & B). Notice that although each messag… Message-Writing GuidelinesManual ChaptersPG18For the ProgrammerHere are some guidelines for writing messages that are easily translatable. Do not construct sentences at run-time, like: printf("Files were %s.\n", flag ? "copied" : "removed"); The word or… Messaging OverviewManual ChaptersPG18OverviewAll communication is through a stream of messages. The first byte of a message identifies the message type, and the next four bytes specify the length of the rest of the message (this length… metaExtensionsExtensionsMonitoring · ExtensionsNormalized, friendlier system catalog for PostgreSQL pg_meta Monitoring Meta-CommandsManual ChaptersPG18psqlAnything you enter in psql that begins with an unquoted backslash is a psql meta-command that is processed by psql itself. These commands make psql more useful for administration or scriptin… meta_triggersExtensionsExtensionsFeatures · ExtensionsInsert, update and delete triggers for the meta system catalog catalog ddl triggers meta_triggers Features metagrationExtensionsExtensionsReplication and streams · ExtensionsMigrate Postgres with Postgres migration pgtap replication metagration Replication and streams