Introduction
Documentation Status
Legal notice
Conventions
Bug Reporting Guidelines
1.
Part I. Internals
❱
1.1.
Architectural Fundamentals
1.2.
Indexes
❱
1.2.1.
B-Tree Indexes
1.2.2.
GiST Indexes
1.2.3.
SP-GiST Indexes
1.2.4.
GIN Indexes
1.2.5.
BRIN Indexes
1.2.6.
Hash Indexes
1.3.
Full Text Search
1.4.
Concurrency Control
1.5.
libpq — C Library
❱
1.5.1.
Database Connection Control Functions
1.5.2.
Connection Status Functions
1.5.3.
Command Execution Functions
1.5.4.
Asynchronous Command Processing
1.5.5.
Pipeline Mode
1.5.6.
Retrieving Query Results Row-by-Row
1.5.7.
Canceling Queries in Progress
1.5.8.
The Fast-Path Interface
1.5.9.
Asynchronous Notification
1.5.10.
Functions Associated with the COPY Command
1.5.11.
Control Functions
1.5.12.
Miscellaneous Functions
1.5.13.
Notice Processing
1.5.14.
Event System
1.5.15.
Environment Variables
1.5.16.
The Password File
1.5.17.
The Connection Service File
1.5.18.
LDAP Lookup of Connection Parameters
1.5.19.
SSL Support
1.5.20.
Behavior in Threaded Programs
1.5.21.
Building libpq Programs
1.5.22.
Example Programs
1.6.
Large Objects
1.7.
The Information Schema
1.8.
Server Programming
❱
1.8.1.
Extending SQL
❱
1.8.1.1.
How Extensibility Works
1.8.1.2.
The QHB Type System
1.8.1.3.
User-Defined Functions
1.8.1.4.
User-Defined Procedures
1.8.1.5.
Query Language (SQL) Functions
1.8.1.6.
Function Overloading
1.8.1.7.
Function Volatility Categories
1.8.1.8.
Procedural Language Functions
1.8.1.9.
Internal Functions
1.8.1.10.
Native Language Functions
1.8.1.11.
Function Optimization Information
1.8.1.12.
User-Defined Aggregates
1.8.1.13.
User-Defined Types
1.8.1.14.
User-Defined Operators
1.8.1.15.
Operator Optimization Information
1.8.1.16.
Interfacing Extensions to Indexes
1.8.1.17.
Packaging Related Objects into an Extension
1.8.1.18.
Extension Building Infrastructure
1.8.2.
Triggers
1.8.3.
Event Triggers
1.8.4.
The Rule System
1.8.5.
Server Programming Interface
1.8.6.
Background Worker Processes
1.8.7.
Logical Decoding
1.8.8.
Replication Progress Tracking
1.8.9.
Archive Modules
1.9.
qhb instance
1.10.
Overview of QHB Internals
1.11.
System Catalogs
1.12.
System Views
1.13.
Frontend/Backend Protocol
❱
1.13.1.
Overview
1.13.2.
Message Flow
1.13.3.
SASL Authentication
1.13.4.
Streaming Replication Protocol
1.13.5.
Logical Streaming Replication Protocol
1.13.6.
Message Data Types
1.13.7.
Message Formats
1.13.8.
Error and Notice Message Fields
1.13.9.
Logical Replication Message Formats
1.13.10.
Summary of Changes since Protocol 2.0
1.14.
Table Access Method Interface Definition
1.15.
Index Access Method Interface Definition
1.16.
Generic WAL Records
1.17.
Custom WAL Resource Managers
1.18.
Database Physical Storage
1.19.
Transaction Processing
1.20.
System Catalog Declarations and Initial Contents
1.21.
How the Planner Uses Statistics
1.22.
Backup Manifest Format
1.23.
QSS Secure Storage Module
❱
1.23.1.
User Guide for Cold Re-encryption of QHB Database Objects
1.24.
QCP Asynchronous Connection Pool
1.25.
QDL Data Bulk Direct Loading Module
❱
1.25.1.
Example of Using QDL
1.26.
QDLM Loading Metric Data into a Database Module
1.27.
TARQ Disk Block Cache Manager
1.28.
Dump and Load of the UMCA Disk Block Cache Manager Contents
1.29.
Parameter HOLDMEM and Additional Disk Block Caches
1.30.
Tables APPEND_ONLY
1.31.
Metric Server
❱
1.31.1.
queryid Metric Configuration
1.32.
Shared Plan Cache
1.33.
Built-in Message Queue
1.34.
QSched Task Scheduler
1.35.
Session Level Variables qhb-variables
1.36.
Profiling Long Queries
1.37.
Cluster Computing Management Module QLUSTER
❱
1.37.1.
qluster rest api Description
1.37.2.
QRAFT Protocol Description
1.38.
QMAN — application for monitoring and managing QHB instances
❱
1.38.1.
QMAN — Command Reference
2.
Part II. Installation and Configuration
❱
2.1.
Installation
2.2.
Getting Started
2.3.
Server Setup and Operation
2.4.
Server Configuration
❱
2.4.1.
Setting Parameters
2.4.2.
File Locations
2.4.3.
Connections and Authentication
2.4.4.
Resource Consumption
2.4.5.
Write Ahead Log
2.4.6.
Replication
2.4.7.
Query Planning
2.4.8.
Error Reporting and Logging
2.4.9.
Run-time Statistics
2.4.10.
Automatic Vacuuming
2.4.11.
Client Connection Defaults
2.4.12.
Lock Management
2.4.13.
Version and Platform Compatibility
2.4.14.
Error Handling
2.4.15.
Preset Options
2.4.16.
Customized Options
2.4.17.
Developer Options
2.4.18.
Short Options
2.4.19.
QHB-specific Module and Extension Options
2.5.
Performance Tips
2.6.
Client Authentication
2.7.
Database Roles
2.8.
Information Security Roles
2.9.
Managing Databases
2.10.
Localization
2.11.
Routine Database Maintenance Tasks
2.12.
Backup and Restore
2.13.
qbackup Backup Tool
2.14.
High Availability, Load Balancing, and Replication
2.15.
Resource Management
2.16.
Monitoring Database Activity
❱
2.16.1.
Standard Unix Tools
2.16.2.
The Cumulative Statistics System
2.16.3.
Viewing Locks
2.16.4.
Progress Reporting
2.16.5.
Dynamic Tracing
2.16.6.
QHB Metrics
2.17.
Monitoring Disk Usage
2.18.
Reliability and the Write-Ahead Log
2.19.
Logical Replication
2.20.
Just-in-Time Compilation (JIT)
2.21.
Regression Tests
2.22.
Procedural Languages
2.23.
Writing a Procedural Language Handler
2.24.
QHB Client Applications
❱
2.24.1.
clusterdb
2.24.2.
createdb
2.24.3.
createuser
2.24.4.
dropdb
2.24.5.
dropuser
2.24.6.
qhb_amcheck
2.24.7.
qhb_basebackup
2.24.8.
pg_config
2.24.9.
qhb_dump
2.24.10.
qhb_dumpall
2.24.11.
qhb_isready
2.24.12.
qhb_receivewal
2.24.13.
qhb_recvlogical
2.24.14.
qhb_restore
2.24.15.
qhb_verifybackup
2.24.16.
psql
2.24.17.
reindexdb
2.24.18.
vacuumdb
2.25.
QHB Server Applications
❱
2.25.1.
initdb
2.25.2.
qhb_archivecleanup
2.25.3.
qhb_bootstrap
2.25.4.
qhb_checksums
2.25.5.
qhb_controldata
2.25.6.
qhb_ctl
2.25.7.
qhb_resetwal
2.25.8.
qhb_rewind
2.25.9.
qhb_test_fsync
2.25.10.
qhb_test_timing
2.25.11.
qhb_upgrade
2.25.12.
qhb_waldump
2.26.
Writing a Foreign Data Wrapper
2.27.
Writing a Table Sampling Method
2.28.
Writing a Custom Scan Provider
2.29.
Genetic Query Optimizer
3.
Part III. The SQL Language
❱
3.1.
The SQL Language. Tutorial on the basics
3.2.
Advanced Features
3.3.
SQL Syntax
3.4.
Data Definition
❱
3.4.1.
Table Basics
3.4.2.
Default Values
3.4.3.
Generated Columns
3.4.4.
Constraints
3.4.5.
System Columns
3.4.6.
Modifying Tables
3.4.7.
Privileges
3.4.8.
Row Security Policies
3.4.9.
Schemas
3.4.10.
Inheritance
3.4.11.
Table Partitioning
3.4.12.
Foreign Data
3.4.13.
Other Database Objects
3.4.14.
Dependency Tracking
3.5.
Data Manipulation
3.6.
Queries
3.7.
Data Types
❱
3.7.1.
Numeric Types
3.7.2.
Monetary Types
3.7.3.
Character Types
3.7.4.
Binary Data Types
3.7.5.
Date/Time Types
3.7.6.
Boolean Type
3.7.7.
Enumerated Types
3.7.8.
Geometric Types
3.7.9.
Network Address Types
3.7.10.
Bit String Types
3.7.11.
Text Search Types
3.7.12.
UUID Type
3.7.13.
XML Type
3.7.14.
JSON Types
3.7.15.
Arrays
3.7.16.
Composite Types
3.7.17.
Range Types
3.7.18.
Domain Types
3.7.19.
Object Identifier Types
3.7.20.
pg_lsn Type
3.7.21.
Pseudo-Types
3.7.22.
UREF Type
3.8.
Functions and Operators
❱
3.8.1.
Logical Operators
3.8.2.
Comparison Functions and Operators
3.8.3.
Mathematical Functions and Operators
3.8.4.
String Functions and Operators
3.8.5.
Binary String Functions and Operators
3.8.6.
Bit String Functions and Operators
3.8.7.
Pattern Matching
3.8.8.
Data Type Formatting Functions
3.8.9.
Date/Time Functions and Operators
3.8.10.
Enum Support Functions
3.8.11.
Geometric Functions and Operators
3.8.12.
Network Address Functions and Operators
3.8.13.
Text Search Functions and Operators
3.8.14.
UUID Functions
3.8.15.
XML Functions
3.8.16.
JSON Functions and Operators
3.8.17.
Sequence Manipulation Functions
3.8.18.
Conditional Expressions
3.8.19.
Array Functions and Operators
3.8.20.
Range/Multirange Functions and Operators
3.8.21.
Aggregate Functions
3.8.22.
Window Functions
3.8.23.
Subquery Expressions
3.8.24.
Row and Array Comparisons
3.8.25.
Set Returning Functions
3.8.26.
System Information Functions and Operators
3.8.27.
System Administration Functions
3.8.28.
Trigger Functions
3.8.29.
Event Trigger Functions
3.8.30.
Statistics Information Functions
3.9.
Type Conversion
3.10.
Parallel Query
3.11.
PL/pgSQL — SQL Procedural Language
❱
3.11.1.
Overview1
3.11.2.
Structure of PL/pgSQL
3.11.3.
Declarations
3.11.4.
Expressions
3.11.5.
Basic Statements
3.11.6.
Control Structures
3.11.7.
Cursors
3.11.8.
Transaction Management
3.11.9.
Errors and Messages
3.11.10.
Trigger Functions
3.11.11.
PL/pgSQL under the Hood
3.11.12.
Tips for Developing in PL/pgSQL
3.11.13.
Porting from Oracle PL/SQL
3.12.
Autonomous Transactions — PL/pgSQL Language Extension
3.13.
SQL Commands
❱
3.13.1.
ABORT
3.13.2.
ALTER AGGREGATE
3.13.3.
ALTER COLLATION
3.13.4.
ALTER CONVERSION
3.13.5.
ALTER DATABASE
3.13.6.
ALTER DEFAULT PRIVILEGES
3.13.7.
ALTER DOMAIN
3.13.8.
ALTER EVENT TRIGGER
3.13.9.
ALTER EXTENSION
3.13.10.
ALTER FOREIGN DATA WRAPPER
3.13.11.
ALTER FOREIGN TABLE
3.13.12.
ALTER FUNCTION
3.13.13.
ALTER GROUP
3.13.14.
ALTER INDEX
3.13.15.
ALTER LANGUAGE
3.13.16.
ALTER LARGE OBJECT
3.13.17.
ALTER MATERIALIZED VIEW
3.13.18.
ALTER OPERATOR
3.13.19.
ALTER OPERATOR CLASS
3.13.20.
ALTER OPERATOR FAMILY
3.13.21.
ALTER POLICY
3.13.22.
ALTER PROCEDURE
3.13.23.
ALTER PROFILE
3.13.24.
ALTER PUBLICATION
3.13.25.
ALTER ROLE
3.13.26.
ALTER ROUTINE
3.13.27.
ALTER RULE
3.13.28.
ALTER SCHEMA
3.13.29.
ALTER SEQUENCE
3.13.30.
ALTER SERVER
3.13.31.
ALTER STATISTICS
3.13.32.
ALTER SUBSCRIPTION
3.13.33.
ALTER SYSTEM
3.13.34.
ALTER TABLE
3.13.35.
ALTER TABLESPACE
3.13.36.
ALTER TEXT SEARCH CONFIGURATION
3.13.37.
ALTER TEXT SEARCH DICTIONARY
3.13.38.
ALTER TEXT SEARCH PARSER
3.13.39.
ALTER TEXT SEARCH TEMPLATE
3.13.40.
ALTER TRIGGER
3.13.41.
ALTER TYPE
3.13.42.
ALTER USER
3.13.43.
ALTER USER MAPPING
3.13.44.
ALTER VIEW
3.13.45.
ANALYZE
3.13.46.
BEGIN
3.13.47.
CALL
3.13.48.
CHECKPOINT
3.13.49.
CLOSE
3.13.50.
CLUSTER
3.13.51.
COMMENT
3.13.52.
COMMIT
3.13.53.
COMMIT PREPARED
3.13.54.
COPY
3.13.55.
CREATE ACCESS METHOD
3.13.56.
CREATE AGGREGATE
3.13.57.
CREATE CAST
3.13.58.
CREATE COLLATION
3.13.59.
CREATE CONVERSION
3.13.60.
CREATE DATABASE
3.13.61.
CREATE DOMAIN
3.13.62.
CREATE EVENT TRIGGER
3.13.63.
CREATE EXTENSION
3.13.64.
CREATE FOREIGN DATA WRAPPER
3.13.65.
CREATE FOREIGN TABLE
3.13.66.
CREATE FUNCTION
3.13.67.
CREATE GROUP
3.13.68.
CREATE INDEX
3.13.69.
CREATE LANGUAGE
3.13.70.
CREATE MATERIALIZED VIEW
3.13.71.
CREATE OPERATOR
3.13.72.
CREATE OPERATOR CLASS
3.13.73.
CREATE OPERATOR FAMILY
3.13.74.
CREATE POLICY
3.13.75.
CREATE PROCEDURE
3.13.76.
CREATE PROFILE
3.13.77.
CREATE PUBLICATION
3.13.78.
CREATE QHBSECUREROLE
3.13.79.
CREATE ROLE
3.13.80.
CREATE RULE
3.13.81.
CREATE SCHEMA
3.13.82.
CREATE SEQUENCE
3.13.83.
CREATE SERVER
3.13.84.
CREATE STATISTICS
3.13.85.
CREATE SUBSCRIPTION
3.13.86.
CREATE TABLE
3.13.87.
CREATE TABLE AS
3.13.88.
CREATE TABLESPACE
3.13.89.
CREATE TEXT SEARCH CONFIGURATION
3.13.90.
CREATE TEXT SEARCH DICTIONARY
3.13.91.
CREATE TEXT SEARCH PARSER
3.13.92.
CREATE TEXT SEARCH TEMPLATE
3.13.93.
CREATE TRANSFORM
3.13.94.
CREATE TRIGGER
3.13.95.
CREATE TYPE
3.13.96.
CREATE USER
3.13.97.
CREATE USER MAPPING
3.13.98.
CREATE VIEW
3.13.99.
DEALLOCATE
3.13.100.
DECLARE
3.13.101.
DELETE
3.13.102.
DISCARD
3.13.103.
DROP ACCESS METHOD
3.13.104.
DROP AGGREGATE
3.13.105.
DROP CAST
3.13.106.
DROP COLLATION
3.13.107.
DROP CONVERSION
3.13.108.
DROP DATABASE
3.13.109.
DROP DOMAIN
3.13.110.
DROP EVENT TRIGGER
3.13.111.
DROP EXTENSION
3.13.112.
DROP FOREIGN DATA WRAPPER
3.13.113.
DROP FOREIGN TABLE
3.13.114.
DROP FUNCTION
3.13.115.
DROP GROUP
3.13.116.
DROP INDEX
3.13.117.
DROP LANGUAGE
3.13.118.
DROP MATERIALIZED VIEW
3.13.119.
DROP OPERATOR
3.13.120.
DROP OPERATOR CLASS
3.13.121.
DROP OPERATOR FAMILY
3.13.122.
DROP OWNED
3.13.123.
DROP POLICY
3.13.124.
DROP PROCEDURE
3.13.125.
DROP PROFILE
3.13.126.
DROP PUBLICATION
3.13.127.
DROP QHBSECUREROLE
3.13.128.
DROP ROLE
3.13.129.
DROP ROUTINE
3.13.130.
DROP RULE
3.13.131.
DROP SCHEMA
3.13.132.
DROP SEQUENCE
3.13.133.
DROP SERVER
3.13.134.
DROP STATISTICS
3.13.135.
DROP SUBSCRIPTION
3.13.136.
DROP TABLE
3.13.137.
DROP TABLESPACE
3.13.138.
DROP TEXT SEARCH CONFIGURATION
3.13.139.
DROP TEXT SEARCH DICTIONARY
3.13.140.
DROP TEXT SEARCH PARSER
3.13.141.
DROP TEXT SEARCH TEMPLATE
3.13.142.
DROP TRANSFORM
3.13.143.
DROP TRIGGER
3.13.144.
DROP TYPE
3.13.145.
DROP USER
3.13.146.
DROP USER MAPPING
3.13.147.
DROP VIEW
3.13.148.
END
3.13.149.
EXECUTE
3.13.150.
EXPLAIN
3.13.151.
FETCH
3.13.152.
GRANT
3.13.153.
IMPORT FOREIGN SCHEMA
3.13.154.
INSERT
3.13.155.
LISTEN
3.13.156.
LOAD
3.13.157.
LOCK
3.13.158.
MERGE
3.13.159.
MOVE
3.13.160.
NOTIFY
3.13.161.
PREPARE
3.13.162.
PREPARE TRANSACTION
3.13.163.
REASSIGN OWNED
3.13.164.
REFRESH MATERIALIZED VIEW
3.13.165.
REINDEX
3.13.166.
RELEASE SAVEPOINT
3.13.167.
RESET
3.13.168.
REVOKE
3.13.169.
ROLLBACK
3.13.170.
ROLLBACK PREPARED
3.13.171.
ROLLBACK TO SAVEPOINT
3.13.172.
SAVEPOINT
3.13.173.
SECURITY LABEL
3.13.174.
SELECT
3.13.175.
SELECT INTO
3.13.176.
SET
3.13.177.
SET CONSTRAINTS
3.13.178.
SET ROLE
3.13.179.
SET SESSION AUTHORIZATION
3.13.180.
SET TRANSACTION
3.13.181.
SHOW
3.13.182.
START TRANSACTION
3.13.183.
TRUNCATE
3.13.184.
UNLISTEN
3.13.185.
UPDATE
3.13.186.
VACUUM
3.13.187.
VALUES
3.14.
SQL Standard Support
❱
3.14.1.
SQL Key Words
3.14.2.
QHB Error Codes
3.14.3.
Date/Time Support
3.14.4.
SQL Conformance
4.
Appendixes
❱
4.1.
Extensions
❱
4.1.1.
QHB Extensions
❱
4.1.1.1.
Rbytea
4.1.1.2.
Qbim
❱
4.1.1.2.1.
Example of Using Qbim for a Test Object
4.1.1.2.2.
Example of Using Qbim with Linked Objects
4.1.1.3.
Qbayes
4.1.1.4.
part_import
4.1.1.5.
qhb_audit
4.1.1.6.
stat_dump
4.1.2.
Specific and Experimental PostgreSQL Modules
❱
4.1.2.1.
adminpack
4.1.2.2.
amcheck
4.1.2.3.
auth_delay
4.1.2.4.
auto_explain
4.1.2.5.
basebackup_to_shell
4.1.2.6.
basic_archive
4.1.2.7.
bloom
4.1.2.8.
btree_gin
4.1.2.9.
btree_gist
4.1.2.10.
citext
4.1.2.11.
cube
4.1.2.12.
dblink
4.1.2.13.
dict_int
4.1.2.14.
dict_xsyn
4.1.2.15.
earthdistance
4.1.2.16.
file_fdw
4.1.2.17.
fuzzystrmatch
4.1.2.18.
hstore
4.1.2.19.
intagg
4.1.2.20.
intarray
4.1.2.21.
isn
4.1.2.22.
lo
4.1.2.23.
ltree
4.1.2.24.
old_snapshot
4.1.2.25.
pageinspect
4.1.2.26.
passwordcheck
4.1.2.27.
pg_buffercache
4.1.2.28.
pgcrypto
4.1.2.29.
pg_freespacemap
4.1.2.30.
pg_prewarm
4.1.2.31.
pgrowlocks
4.1.2.32.
pg_stat_statements
4.1.2.33.
pgstattuple
4.1.2.34.
pg_surgery
4.1.2.35.
pg_trgm
4.1.2.36.
pg_visibility
4.1.2.37.
pg_walinspect
4.1.2.38.
postgres_fdw
4.1.2.39.
seg
4.1.2.40.
sepgsql
4.1.2.41.
spi
4.1.2.42.
sslinfo
4.1.2.43.
tablefunc
4.1.2.44.
tcn
4.1.2.45.
test_decoding
4.1.2.46.
tsm_system_rows
4.1.2.47.
tsm_system_time
4.1.2.48.
unaccent
4.1.2.49.
uuid-ossp
4.1.2.50.
xml2
4.1.3.
Client Applications
❱
4.1.3.1.
oid2name
4.1.3.2.
vacuumlo
4.1.4.
External Extensions
❱
4.1.4.1.
PostGIS
4.1.4.2.
Patroni
4.1.4.3.
mysql_fdw
4.1.4.4.
Orafce
4.1.4.5.
pg_hint_plan
4.1.4.6.
pg_repack
4.1.4.7.
pg_store_plans
4.1.4.8.
pgtt
4.1.4.9.
plpgsql_check
4.1.4.10.
sr_plan
4.2.
Supported Platforms
❱
4.2.1.
1C Solution Support
4.3.
QHB Usage Pattern
4.4.
Differences between QHB and PostgreSQL
4.5.
QHB Features and Benefits
4.6.
Download Page
4.7.
Brief Guides
❱
4.7.1.
Step-by-Step Guides for Initial Download, Installation and Launch
4.7.2.
Brief Upgrade Guide
4.7.3.
Migrating a Database Cluster to QHB
4.7.4.
Starting and Stopping a Server Using systemd Service
4.7.5.
Example of Setting Up a Synchronous Replica
4.7.6.
Example of Logging Setup
4.7.7.
Installing Secure QHB Database
4.7.8.
Installing the QSS Encryption Module Using the Sobol PRNG HSS
4.7.9.
Working with Modules
❱
4.7.9.1.
QCP Installation and Usage Guide
4.7.9.2.
Metric Server Operation in Separate Collector and Aggregator Mode
4.7.10.
Working with 1C
❱
4.7.10.1.
QHB Installation Guide for 1C
4.7.10.2.
Configuring QHB for 1C
4.7.10.3.
QHB Backup for 1C
4.7.11.
Working with the PL/pgSQL Debugger
4.8.
Acronyms
4.9.
Glossary
4.10.
Color Support
4.11.
Licensing
4.12.
Integrity Control
4.13.
Security Profiles
4.14.
Release Notes
4.15.
PostgreSQL Release Notes
Light (default)
Rust
Coal
Navy
Ayu
DBMS «Quantum Hybrid Base» 1.5.3
1.5.3
1.5.2
1.5.1
1.5.1-cert
1.5.0
English
Русский
Working with 1C
QHB Installation Guide for 1C
Configuring QHB for 1C
QHB Backup for 1C