Search PostgreSQL documentation

diameterFunctionsReferencediameter Geometric Functions And Operators 10 diameter of circle diameter ( circle ) → double precision diameter of circle 11 12 13 Computes diameter of circle. diameter ( circle ) → double …Functions · Geometric Functions And Operators dict_excludeExtensionsExtensionsFull-text search dictionary that filters stop words using regular-expression rules. full-text-search regex stopwords dict_exclude Full-text searchFull-text search · Extensions dict_idExtensionsExtensionsIndonesian-language full-text search stemming dictionary based on cSastrawi fts indonesian stemmer dict_id Full-text searchFull-text search · Extensions dict_intExtensionsPG18F.12. dict_int — example full-text search dictionary for integers dict_int is an example of an add-on dictionary template for full-text search. The motivation for this example dictionary is …dict_int — example full-text search dictionary for integers dict_int — example full-text search dictionary for integersManual ChaptersPG18F.12. dict_int — example full-text search dictionary for integers dict_int is an example of an add-on dictionary template for full-text search. The motivation for this example dictionary is …dict_int — example full-text search dictionary for integers dict_maxlenExtensionsExtensionstext search template for a dictionary filtering out long words dict_maxlen Full-text searchFull-text search · Extensions dict_regexExtensionsExtensionsFull-text-search dictionary with regular-expression rules. full-text-search regex dict_regex Full-text searchFull-text search · Extensions dict_romanExtensionsExtensionsFull-text search dictionary that converts Roman numeral tokens to Arabic integers. full-text-search roman-numerals token-normalization dict_roman Full-text searchFull-text search · Extensions dict_translateExtensionsExtensionsText search dictionary template that normalizes lexemes and expands them to configured translations. fts synonym translation dict_translate Full-text searchFull-text search · Extensions dict_voikkoExtensionsExtensionsFinnish full-text-search dictionary using Voikko morphological analysis. finnish full-text-search dict_voikko Full-text searchFull-text search · Extensions dict_xsynExtensionsPG18F.13. dict_xsyn — example synonym full-text search dictionary dict_xsyn (Extended Synonym Dictionary) is an example of an add-on dictionary template for full-text search. This dictionary typ…dict_xsyn — example synonym full-text search dictionary dict_xsyn — example synonym full-text search dictionaryManual ChaptersPG18F.13. dict_xsyn — example synonym full-text search dictionary dict_xsyn (Extended Synonym Dictionary) is an example of an add-on dictionary template for full-text search. This dictionary typ…dict_xsyn — example synonym full-text search dictionary DictionariesManual ChaptersPG1812.6. Dictionaries Dictionaries are used to eliminate words that should not be considered in a search (stop words), and to normalize words so that different derived forms of the same word wi…Dictionaries Dictionary TestingManual ChaptersPG1812.8.3. Dictionary Testing The ts_lexize function facilitates dictionary testing. ts_lexize(dict regdictionary, token text) returns text[] ts_lexize returns an array of lexemes if the input …Dictionary Testing Differences from SQL Standard and XQueryManual ChaptersPG189.7.3.8. Differences from SQL Standard and XQuery Since SQL:2008, the SQL standard includes regular expression operators and functions that performs pattern matching according to the XQuery …Differences from SQL Standard and XQuery digest()Manual ChaptersPG18F.26.1.1. digest() digest(data text, type text) returns bytea digest(data bytea, type text) returns bytea Computes a binary hash of the given data. type is the algorithm to use. Standard alg…digest() dir_fdwExtensionsExtensionsforeign-data wrapper for readdir c dir directory draft example fdw folder foreign-data-wrapper linux postgres postgresql sample ubuntu dir_fdw Foreign data wrappersForeign data wrappers · Extensions Disable AutocommitManual ChaptersPG1814.4.1. Disable Autocommit When using multiple INSERTs, turn off autocommit and just do one commit at the end. (In plain SQL, this means issuing BEGIN at the start and COMMIT at the end. Som…Disable Autocommit Disable WAL Archival and Streaming ReplicationManual ChaptersPG1814.4.7. Disable WAL Archival and Streaming Replication When loading large amounts of data into an installation that uses WAL archiving or streaming replication, it might be faster to take a …Disable WAL Archival and Streaming Replication disable-mdcManual ChaptersPG18F.26.3.8.5. disable-mdc Do not protect data with SHA-1. The only good reason to use this option is to achieve compatibility with ancient PGP products, predating the addition of SHA-1 protect…disable-mdc DISCARDManual ChaptersPG18DISCARD DISCARD — discard session state Synopsis DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP }DISCARD DISCARDSQL CommandsReferenceDISCARD Sessions & Settings 10 discard session state DISCARD { ALL | PLANS | SEQUENCES | TEMPORARY | TEMP } DISCARD releases internal resources associated with a database session. This comma…SQL Commands · Sessions & Settings DISCONNECTManual ChaptersPG18DISCONNECT DISCONNECT — terminate a database connection Synopsis DISCONNECT connection_name DISCONNECT [ CURRENT ] DISCONNECT ALLDISCONNECT 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 DISTINCTSQL CommandsPG187.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 S…Select Lists › DISTINCT 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 divFunctionsReferencediv Mathematical Functions And Operators 10 integer quotient of y/x div ( y numeric, x numeric ) → numeric integer quotient of y/x 11 12 13 Integer quotient of y/x (truncates towards zero) d…Functions · Mathematical Functions And Operators 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 dnaExtensionsExtensionsCompact DNA sequence and k-mer types with comparison, validation, and analysis functions. dna kmer sequence bioinformatics dna Data typesData types · Extensions dna_sequenceExtensionsExtensionsDNA and k-mer types with SP-GiST prefix indexing bioinformatics dna spgist dna_sequence Data typesData types · Extensions DOManual ChaptersPG18DO DO — execute an anonymous code block Synopsis DO [ LANGUAGE lang_name ] codeDO DOSQL CommandsReferenceDO Functions & Procedures 10 execute an anonymous code block DO [ LANGUAGE lang_name ] code DO executes an anonymous code block, or in other words a transient anonymous function in a procedu…SQL Commands · Functions & Procedures 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 documentationExtensionsExtensionsAquameta internal documentation system events plpgsql postgresql rest-api semantics system-catalog version-control-system widgets documentation FeaturesFeatures · Extensions 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