Search PostgreSQL documentation

CaveatsManual ChaptersPG185.11.1. Caveats Note that not all SQL commands are able to work on inheritance hierarchies. Commands that are used for data querying, data modification, or schema modification (e.g., SELECT,…Caveats CaveatsManual ChaptersPG185.12.3.3. Caveats The following caveats apply to partitioning implemented using inheritance: There is no automatic way to verify that all of the CHECK constraints are mutually exclusive. It …Caveats CaveatsManual ChaptersPG1826.4.5. Caveats There are several limitations of hot standby. These can and probably will be fixed in future releases: Full knowledge of running transactions is required before snapshots can…Caveats CaveatsManual ChaptersPG1847.8.2. Caveats In synchronous replication setup, a deadlock can happen, if the transaction has locked [user] catalog tables exclusively. See Section 47.6.2 for information on user catalog t…Caveats CaveatsManual ChaptersPG1813.6. Caveats Some DDL commands, currently only TRUNCATE and the table-rewriting forms of ALTER TABLE, are not MVCC-safe. This means that after the truncation or rewrite commits, the table w…Caveats CaveatsManual ChaptersPG1814.1.3. Caveats There are two significant ways in which run times measured by EXPLAIN ANALYZE can deviate from normal execution of the same query. First, since no output rows are delivered t…Caveats cborExtensionsExtensionsConcise Binary Object Representation data type for PostgreSQL. cbor rfc7049 cbor Data typesData types · Extensions cbrtFunctionsReferencecbrt Mathematical Functions And Operators 10 cube root cbrt ( dp ) → dp cube root 11 12 13 Cube root cbrt ( double precision ) → double precision Cube root 14 15 16 17 18 19 20 9.0 9.1 9.2 9…Functions · Mathematical Functions And Operators cbtreeExtensionsExtensionscounted btree access method access-method btree index cbtree FeaturesFeatures · Extensions ccnumberExtensionsExtensionsdata type representing encrypted CC numbers encryption proof-of-concept ccnumber Data typesData types · Extensions cdb_extension_fwExtensionsExtensionsexperimental framework for PostgreSQL extension boilerplate cdb_extension_fw FeaturesFeatures · Extensions cdb_geocoderExtensionsExtensionsArchived CARTO geocoder extension for administrative, postal, IP, and named-place lookups. geocoder cartodb address postal-code data-services GeospatialGeospatial · Extensions cdc_webhookExtensionsExtensionsChange Data Capture webhook extension cdc_webhook Replication and streamsReplication and streams · Extensions cedarling_pgExtensionsExtensionsPostgreSQL integration for Cedarling authorization decisions, including JWT-aware checks and RLS-oriented helpers. access-management api iam identity kubernetes oauth2 openid-connect pgrx ru…Security · Extensions ceilFunctionsReferenceceil Mathematical Functions And Operators 10 nearest integer greater than or equal to argument ceil ( dp or numeric ) → (same as input) nearest integer greater than or equal to argument 11 1…Functions · Mathematical Functions And Operators ceilingFunctionsReferenceceiling Mathematical Functions And Operators 10 nearest integer greater than or equal to argument (same as ceil) ceiling ( dp or numeric ) → (same as input) nearest integer greater than or e…Functions · Mathematical Functions And Operators cem-uuidv7ExtensionsExtensionsUUIDv7 extension database.dev tle cem-uuidv7 Functions and aggregatesFunctions and aggregates · Extensions centerFunctionsReferencecenter Geometric Functions And Operators 10 center ( object ) → point center 11 12 13 Computes center point. Available for box, circle. center ( geometric_type ) → point Computes center poin…Functions · Geometric Functions And Operators certExtensionsExtensionsPostgreSQL data types and functions for X.509 certificates, certificate requests, and related OpenSSL objects. certificate data-type openssl x509 pg_cert Data typesData types · Extensions Certificate AuthenticationManual ChaptersPG1820.12. Certificate Authentication This authentication method uses SSL client certificates to perform authentication. It is therefore only available for SSL connections; see Section 18.9.2 fo…Certificate Authentication ch_fdwExtensionsExtensionsForeign data wrapper for federated access from PostgreSQL to ClickHouse. clickhouse experimental fdw go ch_fdw Foreign data wrappersForeign data wrappers · Extensions chamkho_parserExtensionsExtensionsRust full-text-search parser using the Chamkho word-cut engine, ported from pg-search-thai. pgrx rust chamkho_parser Full-text searchFull-text search · Extensions Change CallbackManual ChaptersPG1847.6.4.5. Change Callback The required change_cb callback is called for every individual row modification inside a transaction, may it be an INSERT, UPDATE, or DELETE. Even if the original c…Change Callback ChangesManual ChaptersPG18E.5.2. Changes Check for CREATE privileges on the schema in CREATE STATISTICS (Jelte Fennema-Nio) § This omission allowed table owners to create statistics in any schema, potentially leading…Changes ChangesManual ChaptersPG18E.4.2. Changes Guard against unexpected dimensions of oidvector/int2vector (Tom Lane) § These data types are expected to be 1-dimensional arrays containing no nulls, but there are cast pathw…Changes ChangesManual ChaptersPG18E.3.2. Changes Fix failure after replaying a multixid truncation record from WAL that was generated by an older minor version (Heikki Linnakangas) § Erroneous logic for coping with the way t…Changes ChangesManual ChaptersPG18E.2.2. Changes Prevent unbounded recursion while processing startup packets (Michael Paquier) § A malicious client could crash the connected backend by alternating rejected SSL and GSS encry…Changes ChangesManual ChaptersPG18E.1.2. Changes Restrict logical decoding output plugins to the set specified by a new server parameter output_plugin_libraries (Jacob Champion) § § Previously, a replication user could selec…Changes ChangesManual ChaptersPG18E.6.3. Changes Below you will find a detailed account of the changes between PostgreSQL 18 and the previous major release.Changes Changing a Column's Data TypeManual ChaptersPG185.7.6. Changing a Column's Data Type To convert a column to a different data type, use a command like: ALTER TABLE products ALTER COLUMN price TYPE numeric(10,2); This will succeed only if e…Changing a Column's Data Type Changing a Column's Default ValueManual ChaptersPG185.7.5. Changing a Column's Default Value To set a new default for a column, use a command like: ALTER TABLE products ALTER COLUMN price SET DEFAULT 7.77; Note that this doesn't affect any ex…Changing a Column's Default Value Changing Time SourcesManual ChaptersPG18Changing Time Sources On some newer Linux systems, it's possible to change the clock source used to collect timing data at any time. A second example shows the slowdown possible from switchi…Changing Time Sources channel_bindingCommand-line ToolsPG18channel_binding This option controls the client's use of channel binding. A setting of require means that the connection must employ channel binding, prefer means that the client will choose…Database Connection Control Functions › Parameter Key Words char_lengthFunctionsReferencechar_length String Functions And Operators 10 Number of characters in string char_length ( string ) → int Number of characters in string 11 12 13 Returns number of characters in the string. …Functions · String Functions And Operators characterData TypesPG18character [ (n) ] char [ (n) ] fixed-length character stringData Types Character Set SupportManual ChaptersPG1823.3. Character Set Support The character set support in PostgreSQL allows you to store text in a variety of character sets (also called encodings), including single-byte character sets such…Character Set Support Character StringsManual ChaptersPG1834.6.1. Character Strings Some functions such as PGTYPESnumeric_to_asc return a pointer to a freshly allocated character string. These results should be freed with PGTYPESchar_free instead o…Character Strings Character TypesManual ChaptersPG188.3. Character Types Table 8.4. Character Types Name Description character varying(n), varchar(n) variable-length with limit character(n), char(n), bpchar(n) fixed-length, blank-padded bpcha…Character Types character varyingData TypesPG18character varying [ (n) ] varchar [ (n) ] variable-length character stringData Types character_lengthFunctionsReferencecharacter_length String Functions And Operators 10 Number of characters in string character_length ( string ) → int Number of characters in string 11 12 13 Returns number of characters in th…Functions · String Functions And Operators