Search PostgreSQL documentation

Documentation TargetsManual ChaptersPG1817.4.4.3. Documentation Targets html # Build documentation in multi-page HTML format man # Build documentation in man page format docs # Build documentation in multi-page HTML and man page f…Documentation Targets documentdbExtensionsExtensionsAPI surface for DocumentDB for PostgreSQL documentdb CompatibilityCompatibility · Extensions documentdb_coreExtensionsExtensionsCore API surface for DocumentDB on PostgreSQL documentdb CompatibilityCompatibility · Extensions documentdb_distributedExtensionsExtensionsMulti-Node API surface for DocumentDB documentdb CompatibilityCompatibility · Extensions documentdb_extended_rumExtensionsExtensionsDocumentDB Extended RUM index access method documentdb CompatibilityCompatibility · Extensions Doing Nothing At AllManual ChaptersPG1841.5.6. Doing Nothing At All Sometimes a placeholder statement that does nothing is useful. For example, it can indicate that one arm of an if/then/else chain is deliberately empty. For this…Doing Nothing At All Dollar-Quoted String ConstantsManual ChaptersPG184.1.2.4. Dollar-Quoted String Constants While the standard syntax for specifying string constants is usually convenient, it can be difficult to understand when the desired string contains ma…Dollar-Quoted String Constants Domain TypesManual ChaptersPG188.18. Domain Types A domain is a user-defined data type that is based on another underlying type. Optionally, it can have constraints that restrict its valid values to a subset of what the u…Domain Types domain_constraintsManual ChaptersPG1835.21. domain_constraints The view domain_constraints contains all constraints belonging to domains defined in the current database. Only those domains are shown that the current user has ac…domain_constraints domain_udt_usageManual ChaptersPG1835.22. domain_udt_usage The view domain_udt_usage identifies all domains that are based on data types owned by a currently enabled role. Note that in PostgreSQL, built-in data types behave l…domain_udt_usage DomainsManual ChaptersPG1836.2.3. Domains A domain is based on a particular underlying type and for many purposes is interchangeable with its underlying type. However, a domain can have constraints that restrict its …Domains domainsManual ChaptersPG1835.23. domains The view domains contains all domains defined in the current database. Only those domains are shown that the current user has access to (by way of being the owner or having so…domains dont_drop_dbExtensionsExtensionsPrevents DROP DATABASE for databases listed in the dont_drop_db.list setting. drop-database process-utility-hook security shared-preload dont_drop_db AdministrationAdministration · Extensions doomExtensionsExtensionsDOOM in the terminal with curses doom FeaturesFeatures · Extensions douban_fdwExtensionsExtensionsForeign data wrapper for querying Douban public movie-ranking APIs douban fdw movie douban_fdw Foreign data wrappersForeign data wrappers · Extensions doubleFunctionsPG18double ( number ) → double Casts to double. double(5432) → 5432.0pgbench › Notes › Built-In Functions Double MetaphoneManual ChaptersPG18F.16.5. Double Metaphone The Double Metaphone system computes two “sounds like” strings for a given input string — a “primary” and an “alternate”. In most cases they are the same, but for no…Double Metaphone double precisionData TypesPG18double precision float, float8 double precision floating-point number (8 bytes)Data Types drift_detectExtensionsExtensionsDetect structural query-plan changes and record and notify plan drift query-plan monitoring notifications pg-drift MonitoringMonitoring · Extensions DROP ACCESS METHODManual ChaptersPG18DROP ACCESS METHOD DROP ACCESS METHOD — remove an access method Synopsis DROP ACCESS METHOD [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP ACCESS METHOD DROP ACCESS METHODSQL CommandsReferenceDROP ACCESS METHOD Extensions & Access Methods 10 remove an access method DROP ACCESS METHOD [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP ACCESS METHOD removes an existing access method. O…SQL Commands · Extensions & Access Methods DROP AGGREGATEManual ChaptersPG18DROP AGGREGATE DROP AGGREGATE — remove an aggregate function Synopsis DROP AGGREGATE [ IF EXISTS ] name ( aggregate_signature ) [, ...] [ CASCADE | RESTRICT ] where aggregate_signature is: *…DROP AGGREGATE DROP AGGREGATESQL CommandsReferenceDROP AGGREGATE Functions & Procedures 10 remove an aggregate function DROP AGGREGATE [ IF EXISTS ] name ( aggregate_signature ) [, ...] [ CASCADE | RESTRICT ] where aggregate_signature is: …SQL Commands · Functions & Procedures DROP CASTManual ChaptersPG18DROP CAST DROP CAST — remove a cast Synopsis DROP CAST [ IF EXISTS ] (source_type AS target_type) [ CASCADE | RESTRICT ]DROP CAST DROP CASTSQL CommandsReferenceDROP CAST Types & Operators 10 remove a cast DROP CAST [ IF EXISTS ] (source_type AS target_type) [ CASCADE | RESTRICT ] DROP CAST removes a previously defined cast. To be able to drop a cas…SQL Commands · Types & Operators DROP COLLATIONManual ChaptersPG18DROP COLLATION DROP COLLATION — remove a collation Synopsis DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP COLLATION DROP COLLATIONSQL CommandsReferenceDROP COLLATION Types & Operators 10 remove a collation DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP COLLATION removes a previously defined collation. To be able to drop a co…SQL Commands · Types & Operators DROP CONVERSIONManual ChaptersPG18DROP CONVERSION DROP CONVERSION — remove a conversion Synopsis DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP CONVERSION DROP CONVERSIONSQL CommandsReferenceDROP CONVERSION Types & Operators 10 remove a conversion DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP CONVERSION removes a previously defined conversion. To be able to drop…SQL Commands · Types & Operators DROP DATABASEManual ChaptersPG18DROP DATABASE DROP DATABASE — remove a database Synopsis DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ] where option can be: FORCEDROP DATABASE DROP DATABASESQL CommandsReferenceDROP DATABASE Databases & Schemas 10 remove a database DROP DATABASE [ IF EXISTS ] name DROP DATABASE drops a database. It removes the catalog entries for the database and deletes the direct…SQL Commands · Databases & Schemas DROP DOMAINManual ChaptersPG18DROP DOMAIN DROP DOMAIN — remove a domain Synopsis DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP DOMAIN DROP DOMAINSQL CommandsReferenceDROP DOMAIN Types & Operators 10 remove a domain DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP DOMAIN removes a domain. Only the owner of a domain can remove it. IF EXIS…SQL Commands · Types & Operators DROP EVENT TRIGGERManual ChaptersPG18DROP EVENT TRIGGER DROP EVENT TRIGGER — remove an event trigger Synopsis DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP EVENT TRIGGER DROP EVENT TRIGGERSQL CommandsReferenceDROP EVENT TRIGGER Triggers & Rules 10 remove an event trigger DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ] DROP EVENT TRIGGER removes an existing event trigger. To execute t…SQL Commands · Triggers & Rules DROP EXTENSIONManual ChaptersPG18DROP EXTENSION DROP EXTENSION — remove an extension Synopsis DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP EXTENSION DROP EXTENSIONSQL CommandsReferenceDROP EXTENSION Extensions & Access Methods 10 remove an extension DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP EXTENSION removes extensions from the database. Droppi…SQL Commands · Extensions & Access Methods DROP FOREIGN DATA WRAPPERManual ChaptersPG18DROP FOREIGN DATA WRAPPER DROP FOREIGN DATA WRAPPER — remove a foreign-data wrapper Synopsis DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP FOREIGN DATA WRAPPER DROP FOREIGN DATA WRAPPERSQL CommandsReferenceDROP FOREIGN DATA WRAPPER Foreign Data 10 remove a foreign-data wrapper DROP FOREIGN DATA WRAPPER [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ] DROP FOREIGN DATA WRAPPER removes an exist…SQL Commands · Foreign Data DROP FOREIGN TABLEManual ChaptersPG18DROP FOREIGN TABLE DROP FOREIGN TABLE — remove a foreign table Synopsis DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP FOREIGN TABLE