Search PostgreSQL documentation

Discrete Range TypesManual ChaptersPG188.17.7. Discrete Range Types A discrete range is one whose element type has a well-defined “step”, such as integer or date. In these types two elements can be said to be adjacent, when there…Discrete Range Types DiskManual ChaptersPG1819.4.2. Disk temp_file_limit (integer) # Specifies the maximum amount of disk space that a process can use for temporary files, such as sort and hash temporary files, or the storage file for…Disk Disk Full FailureManual ChaptersPG1827.6.2. Disk Full Failure The most important disk monitoring task of a database administrator is to make sure the disk doesn't become full. A filled data disk will not result in data corrupt…Disk Full Failure DISTINCTManual ChaptersPG187.3.3. DISTINCT After the select list has been processed, the result table can optionally be subject to the elimination of duplicate rows. The DISTINCT key word is written directly after SEL…DISTINCT DISTINCT ClauseManual ChaptersPG18DISTINCT Clause If SELECT DISTINCT is specified, all duplicate rows are removed from the result set (one row is kept from each group of duplicates). SELECT ALL specifies the opposite: all ro…DISTINCT Clause DML PermissionsManual ChaptersPG18F.40.5.2. DML Permissions For tables, db_table:select, db_table:insert, db_table:update or db_table:delete are checked for all the referenced target tables depending on the kind of statement…DML Permissions DOManual ChaptersPG18DO DO — execute an anonymous code block Synopsis DO [ LANGUAGE lang_name ] codeDO DocBookManual ChaptersPG18J.1. DocBook The documentation sources are written in DocBook, which is a markup language defined in XML. In what follows, the terms DocBook and XML are both used, but technically they are n…DocBook DocumentationManual ChaptersPG18Appendix J. Documentation PostgreSQL has four primary documentation formats: Plain text, for pre-installation information HTML, for on-line browsing and reference PDF, for printing man pages…Documentation DocumentationManual ChaptersPG1817.4.3.5. Documentation See Section J.2 for the tools needed for building the documentation. -Ddocs={ auto | enabled | disabled } # Enables building the documentation in HTML and man format.…Documentation Documentation AuthoringManual ChaptersPG18J.5. Documentation Authoring The documentation sources are most conveniently modified with an editor that has a mode for editing XML, and even more so if it has some awareness of XML schema …Documentation Authoring 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 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 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 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 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 CASTManual ChaptersPG18DROP CAST DROP CAST — remove a cast Synopsis DROP CAST [ IF EXISTS ] (source_type AS target_type) [ CASCADE | RESTRICT ]DROP CAST DROP COLLATIONManual ChaptersPG18DROP COLLATION DROP COLLATION — remove a collation Synopsis DROP COLLATION [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP COLLATION DROP CONVERSIONManual ChaptersPG18DROP CONVERSION DROP CONVERSION — remove a conversion Synopsis DROP CONVERSION [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP CONVERSION DROP DATABASEManual ChaptersPG18DROP DATABASE DROP DATABASE — remove a database Synopsis DROP DATABASE [ IF EXISTS ] name [ [ WITH ] ( option [, ...] ) ] where option can be: FORCEDROP DATABASE DROP DOMAINManual ChaptersPG18DROP DOMAIN DROP DOMAIN — remove a domain Synopsis DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP DOMAIN 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 EXTENSIONManual ChaptersPG18DROP EXTENSION DROP EXTENSION — remove an extension Synopsis DROP EXTENSION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP EXTENSION 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 TABLEManual ChaptersPG18DROP FOREIGN TABLE DROP FOREIGN TABLE — remove a foreign table Synopsis DROP FOREIGN TABLE [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP FOREIGN TABLE DROP FUNCTIONManual ChaptersPG18DROP FUNCTION DROP FUNCTION — remove a function Synopsis DROP FUNCTION [ IF EXISTS ] name [ ( [ [ argmode ] [ argname ] argtype [, ...] ] ) ] [, ...] [ CASCADE | RESTRICT ]DROP FUNCTION DROP GROUPManual ChaptersPG18DROP GROUP DROP GROUP — remove a database role Synopsis DROP GROUP [ IF EXISTS ] name [, ...]DROP GROUP DROP INDEXManual ChaptersPG18DROP INDEX DROP INDEX — remove an index Synopsis DROP INDEX [ CONCURRENTLY ] [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP INDEX DROP LANGUAGEManual ChaptersPG18DROP LANGUAGE DROP LANGUAGE — remove a procedural language Synopsis DROP [ PROCEDURAL ] LANGUAGE [ IF EXISTS ] name [ CASCADE | RESTRICT ]DROP LANGUAGE DROP MATERIALIZED VIEWManual ChaptersPG18DROP MATERIALIZED VIEW DROP MATERIALIZED VIEW — remove a materialized view Synopsis DROP MATERIALIZED VIEW [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]DROP MATERIALIZED VIEW DROP OPERATORManual ChaptersPG18DROP OPERATOR DROP OPERATOR — remove an operator Synopsis DROP OPERATOR [ IF EXISTS ] name ( { left_type | NONE } , right_type ) [, ...] [ CASCADE | RESTRICT ]DROP OPERATOR DROP OPERATOR CLASSManual ChaptersPG18DROP OPERATOR CLASS DROP OPERATOR CLASS — remove an operator class Synopsis DROP OPERATOR CLASS [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]DROP OPERATOR CLASS DROP OPERATOR FAMILYManual ChaptersPG18DROP OPERATOR FAMILY DROP OPERATOR FAMILY — remove an operator family Synopsis DROP OPERATOR FAMILY [ IF EXISTS ] name USING index_method [ CASCADE | RESTRICT ]DROP OPERATOR FAMILY DROP OWNEDManual ChaptersPG18DROP OWNED DROP OWNED — remove database objects owned by a database role Synopsis DROP OWNED BY { name | CURRENT_ROLE | CURRENT_USER | SESSION_USER } [, ...] [ CASCADE | RESTRICT ]DROP OWNED