Search PostgreSQL documentation

constraint_exclusionConfigurationReferenceconstraint_exclusion Query Tuning 10 Controls the query planner's use of table constraints to optimize queries. The allowed values of constraint_exclusion are on (examine constraints for all…Configuration · Query Tuning constraint_table_usageManual ChaptersPG1835.19. constraint_table_usage The view constraint_table_usage identifies all tables in the current database that are used by some constraint and are owned by a currently enabled role. (This …constraint_table_usage constraint_uniformExtensionsExtensionsThis is an extension for uniforming the names of base table constraints. constraint name constraint renaming constraint uniform name naming convention reformat constraint names renaming cons…Administration · Extensions ConstraintsManual ChaptersPG185.5. Constraints Data types are a way to limit the kind of data that can be stored in a table. For many applications, however, the constraint they provide is too coarse. For example, a colum…Constraints ConstraintsManual ChaptersPG18E.6.3.2.1. Constraints Allow the specification of non-overlapping PRIMARY KEY, UNIQUE, and foreign key constraints (Paul A. Jungwirth) § § This is specified by WITHOUT OVERLAPS for PRIMARY K…Constraints Constraints on RangesManual ChaptersPG188.17.10. Constraints on Ranges While UNIQUE is a natural constraint for scalar values, it is usually unsuitable for range types. Instead, an exclusion constraint is often more appropriate (s…Constraints on Ranges Constructing Composite ValuesManual ChaptersPG188.16.2. Constructing Composite Values To write a composite value as a literal constant, enclose the field values within parentheses and separate them by commas. You can put double quotes aro…Constructing Composite Values Constructing Ranges and MultirangesManual ChaptersPG188.17.6. Constructing Ranges and Multiranges Each range type has a constructor function with the same name as the range type. Using the constructor function is frequently more convenient than…Constructing Ranges and Multiranges Container TypesManual ChaptersPG1836.2.2. Container Types PostgreSQL has three kinds of “container” types, which are types that contain multiple values of other types. These are arrays, composites, and ranges. Arrays can hol…Container Types content_utilsExtensionsExtensionsUtility functions for news management and full-text search. full-text-search news pg_content_utils Full-text searchFull-text search · Extensions CONTINUEManual ChaptersPG1841.6.5.3. CONTINUE CONTINUE [ label ] [ WHEN boolean-expression ]; If no label is given, the next iteration of the innermost loop is begun. That is, all statements remaining in the loop body…CONTINUE Continuous Archiving and Point-in-Time Recovery (PITR)Manual ChaptersPG1825.3. Continuous Archiving and Point-in-Time Recovery (PITR) At all times, PostgreSQL maintains a write ahead log (WAL) in the pg_wal/ subdirectory of the cluster's data directory. The log r…Continuous Archiving and Point-in-Time Recovery (PITR) Continuous Archiving in StandbyManual ChaptersPG1826.2.9. Continuous Archiving in Standby When continuous WAL archiving is used in a standby, there are two different scenarios: the WAL archive can be shared between the primary and the stand…Continuous Archiving in Standby Control Data FunctionsManual ChaptersPG189.27.10. Control Data Functions The functions shown in Table 9.88 print information initialized during initdb, such as the catalog version. They also show information about write-ahead loggi…Control Data Functions Control FunctionsManual ChaptersPG1832.11. Control Functions These functions control miscellaneous details of libpq's behavior. PQclientEncoding # Returns the client encoding. int PQclientEncoding(const PGconn *conn); Note tha…Control Functions Control StructuresManual ChaptersPG1841.6. Control Structures Control structures are probably the most useful (and important) part of PL/pgSQL. With PL/pgSQL's control structures, you can manipulate PostgreSQL data in a very fl…Control Structures ControlFileWait EventsReferenceControlFile LWLock 10 Waiting to read or update the control file or creation of a new WAL file. 11 12 13 Waiting to read or update the pg_control file or create a new WAL file. 14 15 16 17 1…Wait Events · LWLock ControlFileReadWait EventsReferenceControlFileRead IO 10 Waiting for a read from the control file. 11 12 13 Waiting for a read from the pg_control file. 14 15 16 17 18 19 20 The wait is normal when the workload is expected to…Wait Events · IO ControlFileSyncWait EventsReferenceControlFileSync IO 10 Waiting for the control file to reach durable storage. 11 12 13 Waiting for the pg_control file to reach durable storage. 14 15 16 17 18 19 20 The wait is normal when t…Wait Events · IO ControlFileSyncUpdateWait EventsReferenceControlFileSyncUpdate IO 10 Waiting for an update to the control file to reach durable storage. 11 12 13 Waiting for an update to the pg_control file to reach durable storage. 14 15 16 17 18…Wait Events · IO ControlFileWriteWait EventsReferenceControlFileWrite IO 10 Waiting for a write to the control file. 11 12 13 Waiting for a write to the pg_control file. 14 15 16 17 18 19 20 The wait is normal when the workload is expected to …Wait Events · IO ControlFileWriteUpdateWait EventsReferenceControlFileWriteUpdate IO 10 Waiting for a write to update the control file. 11 12 13 Waiting for a write to update the pg_control file. 14 15 16 17 18 19 20 The wait is normal when the work…Wait Events · IO Controlled Object ClassesManual ChaptersPG18F.40.5.1. Controlled Object Classes The security model of SELinux describes all the access control rules as relationships between a subject entity (typically, a client of the database) and a…Controlled Object Classes Controlling Text SearchManual ChaptersPG1812.3. Controlling Text Search To implement full text searching there must be a function to create a tsvector from a document and a tsquery from a user query. Also, we need to return results …Controlling Text Search Controlling the Planner with Explicit JOIN ClausesManual ChaptersPG1814.3. Controlling the Planner with Explicit JOIN Clauses It is possible to control the query planner to some extent by using the explicit JOIN syntax. To see why this matters, we first need …Controlling the Planner with Explicit JOIN Clauses ConventionsManual ChaptersPG183. Conventions The following conventions are used in the synopsis of a command: brackets ([ and ]) indicate optional parts. Braces ({ and }) and vertical lines (|) indicate that you must cho…Conventions convertFunctionsReferenceconvert Binary String Functions And Operators 10 Convert string to dest_encoding. The original encoding is specified by src_encoding. The string must be valid in this encoding. Conversions c…Functions · Binary String Functions And Operators convertExtensionsExtensionsconversion functions for spatial, routing and other specialized uses pgrx pg_convert Functions and aggregatesFunctions and aggregates · Extensions convert-crlfManual ChaptersPG18F.26.3.8.4. convert-crlf Whether to convert \n into \r\n when encrypting and \r\n to \n when decrypting. RFC 4880 specifies that text data should be stored using \r\n line-feeds. Use this to…convert-crlf convert_fromFunctionsReferenceconvert_from Binary String Functions And Operators 10 Convert string to the database encoding. The original encoding is specified by src_encoding. The string must be valid in this encoding. …Functions · Binary String Functions And Operators convert_toFunctionsReferenceconvert_to Binary String Functions And Operators 10 Convert string to dest_encoding. convert_to ( string text, dest_encoding name ) → bytea Convert string to dest_encoding. 11 12 13 Converts…Functions · Binary String Functions And Operators Cooperation with ViewsManual ChaptersPG1839.4.2. Cooperation with Views A simple way to protect view relations from the mentioned possibility that someone can try to run INSERT, UPDATE, or DELETE on them is to let those query trees…Cooperation with Views coordconvExtensionsExtensionsConvert between IAU 1958 Galactic coordinates and J2000 FK5 equatorial coordinates astronomy coordconv GeospatialGeospatial · Extensions COPYManual ChaptersPG18E.6.3.2.2. COPY Add REJECT_LIMIT to control the number of invalid rows COPY FROM can ignore (Atsushi Torikoshi) § This is available when ON_ERROR = 'ignore'. Allow COPY TO to copy rows from …COPY COPYManual ChaptersPG18COPY COPY — copy data between a file and a table Synopsis COPY table_name [ ( column_name [, ...] ) ] FROM { 'filename' | PROGRAM 'command' | STDIN } [ [ WITH ] ( option [, ...] ) ] [ WHERE …COPY COPYSQL CommandsReferenceCOPY Queries & Data 10 copy data between a file and a table COPY table_name [ ( column_name [, ...] ) ] FROM { 'filename' | PROGRAM 'command' | STDIN } [ [ WITH ] ( option [, ...] ) ] COPY …SQL Commands · Queries & Data COPY OperationsManual ChaptersPG1854.2.6. COPY Operations The COPY command allows high-speed bulk data transfer to or from the server. Copy-in and copy-out operations each switch the connection into a distinct sub-protocol, …COPY Operations COPY Progress ReportingManual ChaptersPG1827.4.3. COPY Progress Reporting Whenever COPY is running, the pg_stat_progress_copy view will contain one row for each backend that is currently running a COPY command. The table below descr…COPY Progress Reporting copy_dataExtensionsExtensionssome small postgresql extensions for beginners copy_data Replication and streamsReplication and streams · Extensions copy_parquetExtensionsExtensionsPoC to support PostgreSQL COPY with Apache Parquet copy_parquet Replication and streamsReplication and streams · Extensions