Search PostgreSQL documentation

ParametersManual ChaptersPG18Parameters WORKTRANSACTION # Optional key words. They have no effect. AND CHAIN # If AND CHAIN is specified, a new (not aborted) transaction is immediately started with the same transaction …Parameters ParametersManual ChaptersPG18Parameters savepoint_name The name to give to the new savepoint. If savepoints with the same name already exist, they will be inaccessible until newer identically-named savepoints are releas…Parameters ParametersManual ChaptersPG18Parameters object_nametable_name.column_nameaggregate_namefunction_nameprocedure_nameroutine_name The name of the object to be labeled. Names of objects that reside in schemas (tables, funct…Parameters ParametersManual ChaptersPG18ParametersParameters ParametersManual ChaptersPG18Parameters TEMPORARY or TEMP If specified, the table is created as a temporary table. Refer to CREATE TABLE for details. UNLOGGED If specified, the table is created as an unlogged table. Ref…Parameters ParametersManual ChaptersPG18Parameters SESSION Specifies that the command takes effect for the current session. (This is the default if neither SESSION nor LOCAL appears.) LOCAL Specifies that the command takes effect …Parameters ParametersManual ChaptersPG18Parameters name The name of a run-time parameter. Available parameters are documented in Chapter 19 and on the SET reference page. In addition, there are a few parameters that can be shown b…Parameters ParametersManual ChaptersPG18Parameters Refer to SET TRANSACTION for information on the meaning of the parameters to this statement.Parameters ParametersManual ChaptersPG18Parameters name The name (optionally schema-qualified) of a table to truncate. If ONLY is specified before the table name, only that table is truncated. If ONLY is not specified, the table a…Parameters ParametersManual ChaptersPG18Parameters channel Name of a notification channel (any identifier). * All current listen registrations for this session are cleared.Parameters ParametersManual ChaptersPG18Parameters with_query The WITH clause allows you to specify one or more subqueries that can be referenced by name in the UPDATE query. See Section 7.8 and SELECT for details. table_name The …Parameters ParametersManual ChaptersPG18Parameters FULL Selects “full” vacuum, which can reclaim more space, but takes much longer and exclusively locks the table. This method also requires extra disk space, since it writes a new …Parameters ParametersManual ChaptersPG18Parameters expression A constant or expression to compute and insert at the indicated place in the resulting table (set of rows). In a VALUES list appearing at the top level of an INSERT, an…Parameters pargresExtensionsExtensionsPrototype parallel query execution module for shared-nothing PostgreSQL clusters executor parallel-query planner preload prototype pargres AnalyticsAnalytics · Extensions parodydbExtensionsExtensionsA toy full-text search extension for Postgres, written in Rust using pgrx parodydb Full-text searchFull-text search · Extensions parquet_fdwExtensionsExtensionsRead-only foreign data wrapper for Apache Parquet files parquet_fdw Foreign data wrappersForeign data wrappers · Extensions parquet_ioExtensionsExtensionsImport Parquet rows and export SQL results with Apache Arrow parquet arrow import-export linkmerce Replication and streamsReplication and streams · Extensions parquet_s3_fdwExtensionsExtensionsForeign data wrapper for accessing Parquet files on local filesystems and Amazon S3 from PostgreSQL. fdw parquet pgspider s3 parquet_s3_fdw Foreign data wrappersForeign data wrappers · Extensions parray_ginExtensionsExtensionsGIN index operator class and partial-match operators for text arrays array gin index parray_gin Functions and aggregatesFunctions and aggregates · Extensions parse_identFunctionsReferenceparse_ident String Functions And Operators 10 Split qualified_identifier into an array of identifiers, removing any quoting of individual identifiers. By default, extra characters after the …Functions · String Functions And Operators ParserManual ChaptersPG1851.3.1. Parser The parser has to check the query string (which arrives as plain text) for valid syntax. If the syntax is correct a parse tree is built up and handed back; otherwise an error …Parser Parser TestingManual ChaptersPG1812.8.2. Parser Testing The following functions allow direct testing of a text search parser. ts_parse(parser_name text, document text, OUT tokid integer, OUT token text) returns setof record…Parser Testing ParsersManual ChaptersPG1812.5. Parsers Text search parsers are responsible for splitting raw document text into tokens and identifying each token's type, where the set of possible types is defined by the parser itse…Parsers Parsing DocumentsManual ChaptersPG1812.3.1. Parsing Documents PostgreSQL provides the function to_tsvector for converting a document to the tsvector data type. to_tsvector([ config regconfig, ] document text) returns tsvector …Parsing Documents Parsing QueriesManual ChaptersPG1812.3.2. Parsing Queries PostgreSQL provides the functions to_tsquery, plainto_tsquery, phraseto_tsquery and websearch_to_tsquery for converting a query to the tsquery data type. to_tsquery o…Parsing Queries Partial AggregationManual ChaptersPG1836.12.4. Partial Aggregation Optionally, an aggregate function can support partial aggregation. The idea of partial aggregation is to run the aggregate's state transition function over diffe…Partial Aggregation Partial IndexesManual ChaptersPG1811.8. Partial Indexes A partial index is an index built over a subset of a table; the subset is defined by a conditional expression (called the predicate of the partial index). The index con…Partial Indexes Partial Match AlgorithmManual ChaptersPG1865.4.4.2. Partial Match Algorithm GIN can support “partial match” queries, in which the query does not determine an exact match for one or more keys, but the possible matches fall within a r…Partial Match Algorithm PARTITION BYSQL CommandsPG18PARTITION BY Clause The PARTITION BY clause is a PostgreSQL extension.CREATE TABLE › Compatibility › PARTITION BY Clause PARTITION BY ClauseManual ChaptersPG18PARTITION BY Clause The PARTITION BY clause is a PostgreSQL extension.PARTITION BY Clause Partition MaintenanceManual ChaptersPG185.12.2.2. Partition Maintenance Normally the set of partitions established when initially defining the table is not intended to remain static. It is common to want to remove partitions holdi…Partition Maintenance PARTITION OFSQL CommandsPG18PARTITION OF Clause The PARTITION OF clause is a PostgreSQL extension.CREATE TABLE › Compatibility › PARTITION OF Clause PARTITION OF ClauseManual ChaptersPG18PARTITION OF Clause The PARTITION OF clause is a PostgreSQL extension.PARTITION OF Clause Partition PruningManual ChaptersPG185.12.4. Partition Pruning Partition pruning is a query optimization technique that improves performance for declaratively partitioned tables. As an example: SET enable_partition_pruning = on…Partition Pruning Partitioned TablesManual ChaptersPG1829.4.4. Partitioned Tables If the publication contains a partitioned table, the publication parameter publish_via_partition_root determines which row filter is used. If publish_via_partition…Partitioned Tables Partitioning and Constraint ExclusionManual ChaptersPG185.12.5. Partitioning and Constraint Exclusion Constraint exclusion is a query optimization technique similar to partition pruning. While it is primarily used for partitioning implemented usi…Partitioning and Constraint Exclusion Partitioning Using InheritanceManual ChaptersPG185.12.3. Partitioning Using Inheritance While the built-in declarative partitioning is suitable for most common use cases, there are some circumstances where a more flexible approach may be u…Partitioning Using Inheritance partman_to_cstoreExtensionsExtensionsMove old pg_partman partitions to cstore columnar storage. archive columnar cstore partitioning pg-partman partman_to_cstore AnalyticsAnalytics · Extensions paseExtensionsExtensionsPostgreSQL ultra-high dimensional approximate nearest neighbor search extension. ann similarity vector pase AI and vectorsAI and vectors · Extensions passfileCommand-line ToolsPG18passfile Specifies the name of the file used to store passwords (see Section 32.16). Defaults to ~/.pgpass, or %APPDATA%\postgresql\pgpass.conf on Microsoft Windows. (No error is reported if…Database Connection Control Functions › Parameter Key Words