Search PostgreSQL documentation

Bit String Functions and OperatorsManual ChaptersPG189.6. Bit String Functions and Operators This section describes functions and operators for examining and manipulating bit strings, that is values of the types bit and bit varying. (While onl…Bit String Functions and Operators Bit String TypesManual ChaptersPG188.10. Bit String Types Bit strings are strings of 1's and 0's. They can be used to store or visualize bit masks. There are two SQL bit types: bit(n) and bit varying(n), where n is a positive…Bit String Types Bit-String ConstantsManual ChaptersPG184.1.2.5. Bit-String Constants Bit-string constants look like regular string constants with a B (upper or lower case) immediately before the opening quote (no intervening whitespace), e.g., B…Bit-String Constants BKI CommandsManual ChaptersPG1868.4. BKI Commands create tablename tableoid [bootstrap] [shared_relation] [rowtype_oid oid] (name1 = type1 [FORCE NOT NULL | FORCE NULL ] [, name2 = type2 [FORCE NOT NULL | FORCE NULL ], ..…BKI Commands BKI ExampleManual ChaptersPG1868.6. BKI Example The following sequence of commands will create the table test_table with OID 420, having three columns oid, cola and colb of type oid, int4 and text, respectively, and inse…BKI Example BKI File FormatManual ChaptersPG1868.3. BKI File Format This section describes how the PostgreSQL backend interprets BKI files. This description will be easier to understand if the postgres.bki file is at hand as an example.…BKI File Format bloom — bloom filter index access methodManual ChaptersPG18F.6. bloom — bloom filter index access method bloom provides an index access method based on Bloom filters. A Bloom filter is a space-efficient data structure that is used to test whether an…bloom — bloom filter index access method Boolean Predicate Check ExpressionsManual ChaptersPG189.16.2.1.1. Boolean Predicate Check Expressions As an extension to the SQL standard, a PostgreSQL path expression can be a Boolean predicate, whereas the SQL standard allows predicates only …Boolean Predicate Check Expressions Boolean TypeManual ChaptersPG188.6. Boolean Type PostgreSQL provides the standard SQL type boolean; see Table 8.19. The boolean type can have several states: “true”, “false”, and a third state, “unknown”, which is represe…Boolean Type Bottom-up Index DeletionManual ChaptersPG1865.1.4.2. Bottom-up Index Deletion B-Tree indexes are not directly aware that under MVCC, there might be multiple extant versions of the same logical table row; to an index, each tuple is an…Bottom-up Index Deletion BoxesManual ChaptersPG188.8.4. Boxes Boxes are represented by pairs of points that are opposite corners of the box. Values of type box are specified using any of the following syntaxes: ( ( x1 , y1 ) , ( x2 , y2 ) …Boxes Bracket ExpressionsManual ChaptersPG189.7.3.2. Bracket Expressions A bracket expression is a list of characters enclosed in []. It normally matches any single character from the list (but see below). If the list begins with ^, i…Bracket Expressions BRINManual ChaptersPG1811.2.6. BRIN BRIN indexes (a shorthand for Block Range INdexes) store summaries about the values stored in consecutive physical block ranges of a table. Thus, they are most effective for col…BRIN BRIN FunctionsManual ChaptersPG18F.23.4. BRIN Functions brin_page_type(page bytea) returns text brin_page_type returns the page type of the given BRIN index page, or throws an error if the page is not a valid BRIN page. For…BRIN Functions BRIN IndexesManual ChaptersPG1865.5. BRIN IndexesBRIN Indexes BSD AuthenticationManual ChaptersPG1820.14. BSD Authentication This authentication method operates similarly to password except that it uses BSD Authentication to verify the password. BSD Authentication is used only to validate…BSD Authentication btree_gin — GIN operator classes with B-tree behaviorManual ChaptersPG18F.7. btree_gin — GIN operator classes with B-tree behavior btree_gin provides GIN operator classes that implement B-tree equivalent behavior for the data types int2, int4, int8, float4, floa…btree_gin — GIN operator classes with B-tree behavior btree_gist — GiST operator classes with B-tree behaviorManual ChaptersPG18F.8. btree_gist — GiST operator classes with B-tree behavior btree_gist provides GiST index operator classes that implement B-tree equivalent behavior for the data types int2, int4, int8, fl…btree_gist — GiST operator classes with B-tree behavior Bug Reporting GuidelinesManual ChaptersPG185. Bug Reporting Guidelines When you find a bug in PostgreSQL we want to hear about it. Your bug reports play an important part in making PostgreSQL more reliable because even the utmost car…Bug Reporting Guidelines BugsManual ChaptersPG18Bugs The -- options will not work on FreeBSD or OpenBSD. Use -c instead. This is a bug in the affected operating systems; a future release of PostgreSQL will provide a workaround if this is …Bugs Build Process DetailsManual ChaptersPG1817.3.3.4. Build Process Details --with-includes=DIRECTORIES # DIRECTORIES is a colon-separated list of directories that will be added to the list the compiler searches for header files. If y…Build Process Details Build Process DetailsManual ChaptersPG1817.4.3.4. Build Process Details --auto-features={ auto | enabled | disabled } # Setting this option allows you to override the value of all “auto” features (features that are enabled automat…Build Process Details Building and Installation with Autoconf and MakeManual ChaptersPG1817.3. Building and Installation with Autoconf and MakeBuilding and Installation with Autoconf and Make Building and Installation with MesonManual ChaptersPG1817.4. Building and Installation with MesonBuilding and Installation with Meson Building Indexes ConcurrentlyManual ChaptersPG18Building Indexes Concurrently Creating an index can interfere with regular operation of a database. Normally PostgreSQL locks the table to be indexed against writes and performs the entire i…Building Indexes Concurrently Building libpq ProgramsManual ChaptersPG1832.22. Building libpq Programs To build (i.e., compile and link) a program using libpq you need to do all of the following things: Include the libpq-fe.h header file: #include <libpq-fe.h> I…Building libpq Programs Building the Documentation with MakeManual ChaptersPG18J.3. Building the Documentation with Make Once you have everything set up, change to the directory doc/src/sgml and run one of the commands described in the following subsections to build th…Building the Documentation with Make Building the Documentation with MesonManual ChaptersPG18J.4. Building the Documentation with Meson To build the documentation using Meson, change to the build directory before running one of these commands, or add -C build to the command. To buil…Building the Documentation with Meson Building uuid-osspManual ChaptersPG18F.49.2. Building uuid-ossp Historically this module depended on the OSSP UUID library, which accounts for the module's name. While the OSSP UUID library can still be found at http://www.ossp…Building uuid-ossp Built-In FunctionsManual ChaptersPG18Built-In Functions The functions listed in Table 303 are built into pgbench and may be used in expressions appearing in \set. Table 303. pgbench Functions Function Description Example(s) abs…Built-In Functions Built-in FunctionsManual ChaptersPG1843.3. Built-in FunctionsBuilt-in Functions Built-in Index Access MethodsManual ChaptersPG18Chapter 65. Built-in Index Access MethodsBuilt-in Index Access Methods Built-in Operator ClassesManual ChaptersPG1865.5.2. Built-in Operator Classes The core PostgreSQL distribution includes the BRIN operator classes shown in Table 65.4. The minmax operator classes store the minimum and the maximum value…Built-in Operator Classes Built-in Operator ClassesManual ChaptersPG1865.4.2. Built-in Operator Classes The core PostgreSQL distribution includes the GIN operator classes shown in Table 65.3. (Some of the optional modules described in Appendix F provide additi…Built-in Operator Classes Built-in Operator ClassesManual ChaptersPG1865.2.2. Built-in Operator Classes The core PostgreSQL distribution includes the GiST operator classes shown in Table 65.1. (Some of the optional modules described in Appendix F provide addit…Built-in Operator Classes Built-in Operator ClassesManual ChaptersPG1865.3.2. Built-in Operator Classes The core PostgreSQL distribution includes the SP-GiST operator classes shown in Table 65.2. Table 65.2. Built-in SP-GiST Operator Classes Name Indexable Ope…Built-in Operator Classes Built-in OperatorsManual ChaptersPG18Built-in Operators The arithmetic, bitwise, comparison and logical operators listed in Table 302 are built into pgbench and may be used in expressions appearing in \set. The operators are li…Built-in Operators Built-in ProbesManual ChaptersPG1827.5.2. Built-in Probes A number of standard probes are provided in the source code, as shown in Table 27.49; Table 27.50 shows the types used in the probes. More probes can certainly be add…Built-in Probes Built-in Range and Multirange TypesManual ChaptersPG188.17.1. Built-in Range and Multirange Types PostgreSQL comes with the following built-in range types: int4range — Range of integer, int4multirange — corresponding Multirange int8range — Rang…Built-in Range and Multirange Types byteaManual ChaptersPG1834.4.4.2.4. bytea The handling of the bytea type is similar to that of VARCHAR. The definition on an array of type bytea is converted into a named struct for every variable. A declaration li…bytea