v3.1
- About MogDB
- Quick Start
- MogDB Playground
- Container-based MogDB Installation
- Installation on a Single Node
- MogDB Access
- Use CLI to Access MogDB
- Use GUI to Access MogDB
- Use Middleware to Access MogDB
- Use Programming Language to Access MogDB
- Using Sample Dataset Mogila
- Characteristic Description
- Overview
- High Performance
- CBO Optimizer
- LLVM
- Vectorized Engine
- Hybrid Row-Column Store
- Adaptive Compression
- SQL by pass
- Kunpeng NUMA Architecture Optimization
- High Concurrency of Thread Pools
- SMP for Parallel Execution
- Xlog no Lock Flush
- Parallel Page-based Redo For Ustore
- Row-Store Execution to Vectorized Execution
- Astore Row Level Compression
- BTree Index Compression
- Tracing SQL Function
- Parallel Index Scan
- Enhancement of Tracing Backend Key Thread
- Ordering Operator Optimization
- High Availability (HA)
- Primary/Standby
- Logical Replication
- Logical Backup
- Physical Backup
- Automatic Job Retry upon Failure
- Ultimate RTO
- High Availability Based on the Paxos Protocol
- Cascaded Standby Server
- Delayed Replay
- Adding or Deleting a Standby Server
- Delaying Entering the Maximum Availability Mode
- Parallel Logical Decoding
- DCF
- CM(Cluster Manager)
- Global SysCache
- Using a Standby Node to Build a Standby Node
- Two City and Three Center DR
- CM Cluster Management Component Supporting Two Node Deployment
- Maintainability
- Database Security
- Access Control Model
- Separation of Control and Access Permissions
- Database Encryption Authentication
- Data Encryption and Storage
- Database Audit
- Network Communication Security
- Resource Label
- Unified Audit
- Dynamic Data Anonymization
- Row-Level Access Control
- Password Strength Verification
- Equality Query in a Fully-encrypted Database
- Ledger Database Mechanism
- Transparent Data Encryption
- Enterprise-Level Features
- Support for Functions and Stored Procedures
- SQL Hints
- Full-Text Indexing
- Copy Interface for Error Tolerance
- Partitioning
- Support for Advanced Analysis Functions
- Materialized View
- HyperLogLog
- Creating an Index Online
- Autonomous Transaction
- Global Temporary Table
- Pseudocolumn ROWNUM
- Stored Procedure Debugging
- JDBC Client Load Balancing and Read/Write Isolation
- In-place Update Storage Engine
- Publication-Subscription
- Foreign Key Lock Enhancement
- Data Compression in OLTP Scenarios
- Transaction Async Submit
- Index Creation Parallel Control
- Dynamic Partition Pruning
- COPY Import Optimization
- SQL Running Status Observation
- BRIN Index
- BLOOM Index
- Application Development Interfaces
- AI Capabilities
- AI4DB: Autonomous Database O&M
- DB4AI: Database-driven AI
- AI in DB
- ABO Optimizer
- Middleware
- Installation Guide
- Installation Preparation
- Container Installation
- PTK-based Installation
- OM-based Installation
- Manual Installation
- Recommended Parameter Settings
- Administrator Guide
- Localization
- Routine Maintenance
- Starting and Stopping MogDB
- Using the gsql Client for Connection
- Routine Maintenance
- Checking OS Parameters
- Checking MogDB Health Status
- Checking Database Performance
- Checking and Deleting Logs
- Checking Time Consistency
- Checking The Number of Application Connections
- Routinely Maintaining Tables
- Routinely Recreating an Index
- Exporting and Viewing the WDR
- Data Security Maintenance Suggestions
- Slow SQL Diagnosis
- Log Reference
- Primary and Standby Management
- MOT Engine
- Introducing MOT
- Using MOT
- Concepts of MOT
- Appendix
- Column-store Tables Management
- Backup and Restoration
- Two City and Three Center DR
- Importing and Exporting Data
- Importing Data
- Exporting Data
- Upgrade Guide
- AI Features Guide
- AI Features Overview
- AI4DB: Autonomous Database O&M
- DBMind Mode
- Components that Support DBMind
- AI Sub-functions of the DBMind
- X-Tuner: Parameter Tuning and Diagnosis
- Index-advisor: Index Recommendation
- Slow Query Diagnosis: Root Cause Analysis for Slow SQL Statements
- Forecast: Trend Prediction
- SQLdiag: Slow SQL Discovery
- SQL Rewriter
- Anomaly Detection
- DB4AI: Database-driven AI
- AI in DB
- Intelligence Explain: SQL Statement Query Time Prediction
- ABO Optimizer
- Intelligent Cardinality Estimation
- Adaptive Plan Selection
- Security Guide
- Developer Guide
- Application Development Guide
- Development Specifications
- Development Based on JDBC
- Overview
- JDBC Package, Driver Class, and Environment Class
- Development Process
- Loading the Driver
- Connecting to a Database
- Connecting to the Database (Using SSL)
- Connecting to the Database (Using UDS)
- Running SQL Statements
- Processing Data in a Result Set
- Closing a Connection
- Managing Logs
- Example: Common Operations
- Example: Retrying SQL Queries for Applications
- Example: Importing and Exporting Data Through Local Files
- Example 2: Migrating Data from a MY Database to MogDB
- Example: Logic Replication Code
- Example: Parameters for Connecting to the Database in Different Scenarios
- JDBC API Reference
- java.sql.Connection
- java.sql.CallableStatement
- java.sql.DatabaseMetaData
- java.sql.Driver
- java.sql.PreparedStatement
- java.sql.ResultSet
- java.sql.ResultSetMetaData
- java.sql.Statement
- javax.sql.ConnectionPoolDataSource
- javax.sql.DataSource
- javax.sql.PooledConnection
- javax.naming.Context
- javax.naming.spi.InitialContextFactory
- CopyManager
- JDBC-based Common Parameter Reference
- Development Based on ODBC
- Development Based on libpq
- Dependent Header Files of libpq
- Development Process
- Example
- Link Parameters
- libpq API Reference
- Database Connection Control Functions
- Database Statement Execution Functions
- Functions for Asynchronous Command Processing
- Functions for Canceling Queries in Progress
- Psycopg-Based Development
- Commissioning
- Stored Procedure
- User Defined Functions
- PL/pgSQL-SQL Procedural Language
- Scheduled Jobs
- Autonomous Transaction
- Logical Replication
- Extension
- Materialized View
- Materialized View Overview
- Full Materialized View
- Incremental Materialized View
- Partition Management
- Partition Pruning
- Recommendations For Choosing A Partitioning Strategy
- Application Development Guide
- Performance Tuning Guide
- System Optimization
- SQL Optimization
- WDR Snapshot
- Using the Vectorized Executor for Tuning
- TPC-C Performance Tunning Guide
- Reference Guide
- System Catalogs and System Views
- Overview of System Catalogs and System Views
- System Catalogs
- GS_ASP
- GS_AUDITING_POLICY
- GS_AUDITING_POLICY_ACCESS
- GS_AUDITING_POLICY_FILTERS
- GS_AUDITING_POLICY_PRIVILEGES
- GS_CLIENT_GLOBAL_KEYS
- GS_CLIENT_GLOBAL_KEYS_ARGS
- GS_COLUMN_KEYS
- GS_COLUMN_KEYS_ARGS
- GS_DB_PRIVILEGE
- GS_ENCRYPTED_COLUMNS
- GS_ENCRYPTED_PROC
- GS_GLOBAL_CHAIN
- GS_GLOBAL_CONFIG
- GS_MASKING_POLICY
- GS_MASKING_POLICY_ACTIONS
- GS_MASKING_POLICY_FILTERS
- GS_MATVIEW
- GS_MATVIEW_DEPENDENCY
- GS_MODEL_WAREHOUSE
- GS_OPT_MODEL
- GS_PACKAGE
- GS_POLICY_LABEL
- GS_RECYCLEBIN
- GS_TXN_SNAPSHOT
- GS_UID
- GS_WLM_EC_OPERATOR_INFO
- GS_WLM_INSTANCE_HISTORY
- GS_WLM_OPERATOR_INFO
- GS_WLM_PLAN_ENCODING_TABLE
- GS_WLM_PLAN_OPERATOR_INFO
- GS_WLM_SESSION_QUERY_INFO_ALL
- GS_WLM_USER_RESOURCE_HISTORY
- PG_AGGREGATE
- PG_AM
- PG_AMOP
- PG_AMPROC
- PG_APP_WORKLOADGROUP_MAPPING
- PG_ATTRDEF
- PG_ATTRIBUTE
- PG_AUTH_HISTORY
- PG_AUTH_MEMBERS
- PG_AUTHID
- PG_CAST
- PG_CLASS
- PG_COLLATION
- PG_CONSTRAINT
- PG_CONVERSION
- PG_DATABASE
- PG_DB_ROLE_SETTING
- PG_DEFAULT_ACL
- PG_DEPEND
- PG_DESCRIPTION
- PG_DIRECTORY
- PG_ENUM
- PG_EXTENSION
- PG_EXTENSION_DATA_SOURCE
- PG_FOREIGN_DATA_WRAPPER
- PG_FOREIGN_SERVER
- PG_FOREIGN_TABLE
- PG_HASHBUCKET
- PG_INDEX
- PG_INHERITS
- PG_JOB
- PG_JOB_PROC
- PG_LANGUAGE
- PG_LARGEOBJECT
- PG_LARGEOBJECT_METADATA
- PG_NAMESPACE
- PG_OBJECT
- PG_OPCLASS
- PG_OPERATOR
- PG_OPFAMILY
- PG_PARTITION
- PG_PLTEMPLATE
- PG_PROC
- PG_PUBLICATION
- PG_PUBLICATION_REL
- PG_RANGE
- PG_REPLICATION_ORIGIN
- PG_RESOURCE_POOL
- PG_REWRITE
- PG_RLSPOLICY
- PG_SECLABEL
- PG_SET
- PG_SHDEPEND
- PG_SHDESCRIPTION
- PG_SHSECLABEL
- PG_STATISTIC
- PG_STATISTIC_EXT
- PG_SUBSCRIPTION
- PG_SYNONYM
- PG_TABLESPACE
- PG_TRIGGER
- PG_TS_CONFIG
- PG_TS_CONFIG_MAP
- PG_TS_DICT
- PG_TS_PARSER
- PG_TS_TEMPLATE
- PG_TYPE
- PG_USER_MAPPING
- PG_USER_STATUS
- PG_WORKLOAD_GROUP
- PGXC_CLASS
- PGXC_GROUP
- PGXC_NODE
- PGXC_SLICE
- PLAN_TABLE_DATA
- STATEMENT_HISTORY
- System Views
- DV_SESSION_LONGOPS
- DV_SESSIONS
- GET_GLOBAL_PREPARED_XACTS(Discarded)
- GS_AUDITING
- GS_AUDITING_ACCESS
- GS_AUDITING_PRIVILEGE
- GS_ASYNC_SUBMIT_SESSIONS_STATUS
- GS_CLUSTER_RESOURCE_INFO
- GS_COMPRESSION
- GS_DB_PRIVILEGES
- GS_FILE_STAT
- GS_GSC_MEMORY_DETAIL
- GS_INSTANCE_TIME
- GS_LABELS
- GS_LSC_MEMORY_DETAIL
- GS_MASKING
- GS_MATVIEWS
- GS_OS_RUN_INFO
- GS_REDO_STAT
- GS_SESSION_CPU_STATISTICS
- GS_SESSION_MEMORY
- GS_SESSION_MEMORY_CONTEXT
- GS_SESSION_MEMORY_DETAIL
- GS_SESSION_MEMORY_STATISTICS
- GS_SESSION_STAT
- GS_SESSION_TIME
- GS_SQL_COUNT
- GS_STAT_SESSION_CU
- GS_THREAD_MEMORY_CONTEXT
- GS_TOTAL_MEMORY_DETAIL
- GS_WLM_CGROUP_INFO
- GS_WLM_EC_OPERATOR_STATISTICS
- GS_WLM_OPERATOR_HISTORY
- GS_WLM_OPERATOR_STATISTICS
- GS_WLM_PLAN_OPERATOR_HISTORY
- GS_WLM_REBUILD_USER_RESOURCE_POOL
- GS_WLM_RESOURCE_POOL
- GS_WLM_SESSION_HISTORY
- GS_WLM_SESSION_INFO
- GS_WLM_SESSION_INFO_ALL
- GS_WLM_SESSION_STATISTICS
- GS_WLM_USER_INFO
- GS_WRITE_TERM_LOG
- MPP_TABLES
- PG_AVAILABLE_EXTENSION_VERSIONS
- PG_AVAILABLE_EXTENSIONS
- PG_COMM_DELAY
- PG_COMM_RECV_STREAM
- PG_COMM_SEND_STREAM
- PG_COMM_STATUS
- PG_CONTROL_GROUP_CONFIG
- PG_CURSORS
- PG_EXT_STATS
- PG_GET_INVALID_BACKENDS
- PG_GET_SENDERS_CATCHUP_TIME
- PG_GROUP
- PG_GTT_ATTACHED_PIDS
- PG_GTT_RELSTATS
- PG_GTT_STATS
- PG_INDEXES
- PG_LOCKS
- PG_NODE_ENV
- PG_OS_THREADS
- PG_PREPARED_STATEMENTS
- PG_PREPARED_XACTS
- PG_PUBLICATION_TABLES
- PG_REPLICATION_ORIGIN_STATUS
- PG_REPLICATION_SLOTS
- PG_RLSPOLICIES
- PG_ROLES
- PG_RULES
- PG_RUNNING_XACTS
- PG_SECLABELS
- PG_SESSION_IOSTAT
- PG_SESSION_WLMSTAT
- PG_SETTINGS
- PG_SHADOW
- PG_STAT_ACTIVITY
- PG_STAT_ACTIVITY_NG
- PG_STAT_ALL_INDEXES
- PG_STAT_ALL_TABLES
- PG_STAT_BAD_BLOCK
- PG_STAT_BGWRITER
- PG_STAT_DATABASE
- PG_STAT_DATABASE_CONFLICTS
- PG_STAT_REPLICATION
- PG_STAT_SUBSCRIPTION
- PG_STAT_SYS_INDEXES
- PG_STAT_SYS_TABLES
- PG_STAT_USER_FUNCTIONS
- PG_STAT_USER_INDEXES
- PG_STAT_USER_TABLES
- PG_STAT_XACT_ALL_TABLES
- PG_STAT_XACT_SYS_TABLES
- PG_STAT_XACT_USER_FUNCTIONS
- PG_STAT_XACT_USER_TABLES
- PG_STATIO_ALL_INDEXES
- PG_STATIO_ALL_SEQUENCES
- PG_STATIO_ALL_TABLES
- PG_STATIO_SYS_INDEXES
- PG_STATIO_SYS_SEQUENCES
- PG_STATIO_SYS_TABLES
- PG_STATIO_USER_INDEXES
- PG_STATIO_USER_SEQUENCES
- PG_STATIO_USER_TABLES
- PG_STATS
- PG_TABLES
- PG_TDE_INFO
- PG_THREAD_WAIT_STATUS
- PG_TIMEZONE_ABBREVS
- PG_TIMEZONE_NAMES
- PG_TOTAL_MEMORY_DETAIL
- PG_TOTAL_USER_RESOURCE_INFO
- PG_TOTAL_USER_RESOURCE_INFO_OID
- PG_USER
- PG_USER_MAPPINGS
- PG_VARIABLE_INFO
- PG_VIEWS
- PG_WLM_STATISTICS
- PGXC_PREPARED_XACTS
- PLAN_TABLE
- Functions and Operators
- Logical Operators
- Comparison Operators
- Character Processing Functions and Operators
- Binary String Functions and Operators
- Bit String Functions and Operators
- Mode Matching Operators
- Mathematical Functions and Operators
- Date and Time Processing Functions and Operators
- Type Conversion Functions
- Geometric Functions and Operators
- Network Address Functions and Operators
- Text Search Functions and Operators
- JSON/JSONB Functions and Operators
- HLL Functions and Operators
- SEQUENCE Functions
- Array Functions and Operators
- Range Functions and Operators
- Aggregate Functions
- Window Functions(Analysis Functions)
- Security Functions
- Ledger Database Functions
- Encrypted Equality Functions
- Set Returning Functions
- Conditional Expression Functions
- System Information Functions
- System Administration Functions
- Configuration Settings Functions
- Universal File Access Functions
- Server Signal Functions
- Backup and Restoration Control Functions
- Snapshot Synchronization Functions
- Database Object Functions
- Advisory Lock Functions
- Logical Replication Functions
- Segment-Page Storage Functions
- Other Functions
- Undo System Functions
- Row-Store Compression System Functions
- Statistics Information Functions
- Trigger Functions
- Hash Function
- Prompt Message Function
- Global Temporary Table Functions
- Fault Injection System Function
- AI Feature Functions
- Dynamic Data Masking Functions
- Other System Functions
- Internal Functions
- Global SysCache Feature Functions
- Data Damage Detection and Repair Functions
- Obsolete Functions
- Supported Data Types
- Numeric Types
- Monetary Types
- Boolean Types
- Enumerated Types
- Character Types
- Binary Types
- Date/Time Types
- Geometric
- Network Address Types
- Bit String Types
- Text Search Types
- UUID
- JSON/JSONB Types
- HLL
- Array Types
- Range
- OID Types
- Pseudo-Types
- Data Types Supported by Column-store Tables
- XML Types
- Data Type Used by the Ledger Database
- SET Type
- SQL Syntax
- ABORT
- ALTER AGGREGATE
- ALTER AUDIT POLICY
- ALTER DATABASE
- ALTER DATA SOURCE
- ALTER DEFAULT PRIVILEGES
- ALTER DIRECTORY
- ALTER EXTENSION
- ALTER FOREIGN TABLE
- ALTER FUNCTION
- ALTER GLOBAL CONFIGURATION
- ALTER GROUP
- ALTER INDEX
- ALTER LANGUAGE
- ALTER LARGE OBJECT
- ALTER MASKING POLICY
- ALTER MATERIALIZED VIEW
- ALTER PACKAGE
- ALTER PROCEDURE
- ALTER PUBLICATION
- ALTER RESOURCE LABEL
- ALTER RESOURCE POOL
- ALTER ROLE
- ALTER ROW LEVEL SECURITY POLICY
- ALTER RULE
- ALTER SCHEMA
- ALTER SEQUENCE
- ALTER SERVER
- ALTER SESSION
- ALTER SUBSCRIPTION
- ALTER SYNONYM
- ALTER SYSTEM KILL SESSION
- ALTER SYSTEM SET
- ALTER TABLE
- ALTER TABLE PARTITION
- ALTER TABLE SUBPARTITION
- ALTER TABLESPACE
- ALTER TEXT SEARCH CONFIGURATION
- ALTER TEXT SEARCH DICTIONARY
- ALTER TRIGGER
- ALTER TYPE
- ALTER USER
- ALTER USER MAPPING
- ALTER VIEW
- ANALYZE | ANALYSE
- BEGIN
- CALL
- CHECKPOINT
- CLEAN CONNECTION
- CLOSE
- CLUSTER
- COMMENT
- COMMIT | END
- COMMIT PREPARED
- CONNECT BY
- COPY
- CREATE AGGREGATE
- CREATE AUDIT POLICY
- CREATE CAST
- CREATE CLIENT MASTER KEY
- CREATE COLUMN ENCRYPTION KEY
- CREATE DATABASE
- CREATE DATA SOURCE
- CREATE DIRECTORY
- CREATE EXTENSION
- CREATE FOREIGN TABLE
- CREATE FUNCTION
- CREATE GROUP
- CREATE INCREMENTAL MATERIALIZED VIEW
- CREATE INDEX
- CREATE LANGUAGE
- CREATE MASKING POLICY
- CREATE MATERIALIZED VIEW
- CREATE MODEL
- CREATE OPERATOR
- CREATE PACKAGE
- CREATE PROCEDURE
- CREATE PUBLICATION
- CREATE RESOURCE LABEL
- CREATE RESOURCE POOL
- CREATE ROLE
- CREATE ROW LEVEL SECURITY POLICY
- CREATE RULE
- CREATE SCHEMA
- CREATE SEQUENCE
- CREATE SERVER
- CREATE SUBSCRIPTION
- CREATE SYNONYM
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLE PARTITION
- CREATE TABLE SUBPARTITION
- CREATE TABLESPACE
- CREATE TEXT SEARCH CONFIGURATION
- CREATE TEXT SEARCH DICTIONARY
- CREATE TRIGGER
- CREATE TYPE
- CREATE USER
- CREATE USER MAPPING
- CREATE VIEW
- CREATE WEAK PASSWORD DICTIONARY
- CURSOR
- DEALLOCATE
- DECLARE
- DELETE
- DO
- DROP AGGREGATE
- DROP AUDIT POLICY
- DROP CAST
- DROP CLIENT MASTER KEY
- DROP COLUMN ENCRYPTION KEY
- DROP DATABASE
- DROP DATA SOURCE
- DROP DIRECTORY
- DROP EXTENSION
- DROP FOREIGN TABLE
- DROP FUNCTION
- DROP GLOBAL CONFIGURATION
- DROP GROUP
- DROP INDEX
- DROP LANGUAGE
- DROP MASKING POLICY
- DROP MATERIALIZED VIEW
- DROP MODEL
- DROP OPERATOR
- DROP OWNED
- DROP PACKAGE
- DROP PROCEDURE
- DROP PUBLICATION
- DROP RESOURCE LABEL
- DROP RESOURCE POOL
- DROP ROLE
- DROP ROW LEVEL SECURITY POLICY
- DROP RULE
- DROP SCHEMA
- DROP SEQUENCE
- DROP SERVER
- DROP SUBSCRIPTION
- DROP SYNONYM
- DROP TABLE
- DROP TABLESPACE
- DROP TEXT SEARCH CONFIGURATION
- DROP TEXT SEARCH DICTIONARY
- DROP TRIGGER
- DROP TYPE
- DROP USER
- DROP USER MAPPING
- DROP VIEW
- DROP WEAK PASSWORD DICTIONARY
- EXECUTE
- EXECUTE DIRECT
- EXPLAIN
- EXPLAIN PLAN
- FETCH
- GRANT
- INSERT
- LOCK
- MERGE INTO
- MOVE
- PREDICT BY
- PREPARE
- PREPARE TRANSACTION
- PURGE
- REASSIGN OWNED
- REFRESH INCREMENTAL MATERIALIZED VIEW
- REFRESH MATERIALIZED VIEW
- REINDEX
- RELEASE SAVEPOINT
- RESET
- REVOKE
- ROLLBACK
- ROLLBACK PREPARED
- ROLLBACK TO SAVEPOINT
- SAVEPOINT
- SELECT
- SELECT INTO
- SET
- SET CONSTRAINTS
- SET ROLE
- SET SESSION AUTHORIZATION
- SET TRANSACTION
- SHOW
- SHUTDOWN
- SNAPSHOT
- START TRANSACTION
- TIMECAPSULE TABLE
- TRUNCATE
- UPDATE
- VACUUM
- VALUES
- SHRINK
- SQL Reference
- MogDB SQL
- Keywords
- Constant and Macro
- Expressions
- Type Conversion
- Full Text Search
- Introduction
- Tables and Indexes
- Controlling Text Search
- Additional Features
- Parser
- Dictionaries
- Configuration Examples
- Testing and Debugging Text Search
- Limitations
- System Operation
- Controlling Transactions
- DDL Syntax Overview
- DML Syntax Overview
- DCL Syntax Overview
- Appendix
- GUC Parameters
- GUC Parameter Usage
- GUC Parameter List
- File Location
- Connection and Authentication
- Resource Consumption
- Write Ahead Log
- HA Replication
- Memory Table
- Query Planning
- Error Reporting and Logging
- Alarm Detection
- Statistics During the Database Running
- Load Management
- Automatic Vacuuming
- Default Settings of Client Connection
- Lock Management
- Version and Platform Compatibility
- Faut Tolerance
- Connection Pool Parameters
- MogDB Transaction
- Replication Parameters of Two Database Instances
- Developer Options
- Auditing
- CM Parameters
- Upgrade Parameters
- Miscellaneous Parameters
- Wait Events
- Query
- System Performance Snapshot
- Security Configuration
- Global Temporary Table
- HyperLogLog
- Scheduled Task
- Thread Pool
- User-defined Functions
- Backup and Restoration
- Undo
- DCF Parameters Settings
- Flashback
- Rollback Parameters
- Reserved Parameters
- AI Features
- Global SysCache Parameters
- Parameters Related to Efficient Data Compression Algorithms
- Appendix
- Schema
- Overview
- Information Schema
- DBE_PERF
- Overview
- OS
- Instance
- Memory
- File
- Object
- STAT_USER_TABLES
- SUMMARY_STAT_USER_TABLES
- GLOBAL_STAT_USER_TABLES
- STAT_USER_INDEXES
- SUMMARY_STAT_USER_INDEXES
- GLOBAL_STAT_USER_INDEXES
- STAT_SYS_TABLES
- SUMMARY_STAT_SYS_TABLES
- GLOBAL_STAT_SYS_TABLES
- STAT_SYS_INDEXES
- SUMMARY_STAT_SYS_INDEXES
- GLOBAL_STAT_SYS_INDEXES
- STAT_ALL_TABLES
- SUMMARY_STAT_ALL_TABLES
- GLOBAL_STAT_ALL_TABLES
- STAT_ALL_INDEXES
- SUMMARY_STAT_ALL_INDEXES
- GLOBAL_STAT_ALL_INDEXES
- STAT_DATABASE
- SUMMARY_STAT_DATABASE
- GLOBAL_STAT_DATABASE
- STAT_DATABASE_CONFLICTS
- SUMMARY_STAT_DATABASE_CONFLICTS
- GLOBAL_STAT_DATABASE_CONFLICTS
- STAT_XACT_ALL_TABLES
- SUMMARY_STAT_XACT_ALL_TABLES
- GLOBAL_STAT_XACT_ALL_TABLES
- STAT_XACT_SYS_TABLES
- SUMMARY_STAT_XACT_SYS_TABLES
- GLOBAL_STAT_XACT_SYS_TABLES
- STAT_XACT_USER_TABLES
- SUMMARY_STAT_XACT_USER_TABLES
- GLOBAL_STAT_XACT_USER_TABLES
- STAT_XACT_USER_FUNCTIONS
- SUMMARY_STAT_XACT_USER_FUNCTIONS
- GLOBAL_STAT_XACT_USER_FUNCTIONS
- STAT_BAD_BLOCK
- SUMMARY_STAT_BAD_BLOCK
- GLOBAL_STAT_BAD_BLOCK
- STAT_USER_FUNCTIONS
- SUMMARY_STAT_USER_FUNCTIONS
- GLOBAL_STAT_USER_FUNCTIONS
- Workload
- Session/Thread
- SESSION_STAT
- GLOBAL_SESSION_STAT
- SESSION_TIME
- GLOBAL_SESSION_TIME
- SESSION_MEMORY
- GLOBAL_SESSION_MEMORY
- SESSION_MEMORY_DETAIL
- GLOBAL_SESSION_MEMORY_DETAIL
- SESSION_STAT_ACTIVITY
- GLOBAL_SESSION_STAT_ACTIVITY
- THREAD_WAIT_STATUS
- GLOBAL_THREAD_WAIT_STATUS
- LOCAL_THREADPOOL_STATUS
- GLOBAL_THREADPOOL_STATUS
- SESSION_CPU_RUNTIME
- SESSION_MEMORY_RUNTIME
- STATEMENT_IOSTAT_COMPLEX_RUNTIME
- LOCAL_ACTIVE_SESSION
- Transaction
- Query
- STATEMENT
- SUMMARY_STATEMENT
- STATEMENT_COUNT
- GLOBAL_STATEMENT_COUNT
- SUMMARY_STATEMENT_COUNT
- GLOBAL_STATEMENT_COMPLEX_HISTORY
- GLOBAL_STATEMENT_COMPLEX_HISTORY_TABLE
- GLOBAL_STATEMENT_COMPLEX_RUNTIME
- STATEMENT_RESPONSETIME_PERCENTILE
- STATEMENT_COMPLEX_RUNTIME
- STATEMENT_COMPLEX_HISTORY_TABLE
- STATEMENT_COMPLEX_HISTORY
- STATEMENT_WLMSTAT_COMPLEX_RUNTIME
- STATEMENT_HISTORY
- Cache/IO
- STATIO_USER_TABLES
- SUMMARY_STATIO_USER_TABLES
- GLOBAL_STATIO_USER_TABLES
- STATIO_USER_INDEXES
- SUMMARY_STATIO_USER_INDEXES
- GLOBAL_STATIO_USER_INDEXES
- STATIO_USER_SEQUENCES
- SUMMARY_STATIO_USER_SEQUENCES
- GLOBAL_STATIO_USER_SEQUENCES
- STATIO_SYS_TABLES
- SUMMARY_STATIO_SYS_TABLES
- GLOBAL_STATIO_SYS_TABLES
- STATIO_SYS_INDEXES
- SUMMARY_STATIO_SYS_INDEXES
- GLOBAL_STATIO_SYS_INDEXES
- STATIO_SYS_SEQUENCES
- SUMMARY_STATIO_SYS_SEQUENCES
- GLOBAL_STATIO_SYS_SEQUENCES
- STATIO_ALL_TABLES
- SUMMARY_STATIO_ALL_TABLES
- GLOBAL_STATIO_ALL_TABLES
- STATIO_ALL_INDEXES
- SUMMARY_STATIO_ALL_INDEXES
- GLOBAL_STATIO_ALL_INDEXES
- STATIO_ALL_SEQUENCES
- SUMMARY_STATIO_ALL_SEQUENCES
- GLOBAL_STATIO_ALL_SEQUENCES
- GLOBAL_STAT_DB_CU
- GLOBAL_STAT_SESSION_CU
- Utility
- REPLICATION_STAT
- GLOBAL_REPLICATION_STAT
- REPLICATION_SLOTS
- GLOBAL_REPLICATION_SLOTS
- BGWRITER_STAT
- GLOBAL_BGWRITER_STAT
- GLOBAL_CKPT_STATUS
- GLOBAL_DOUBLE_WRITE_STATUS
- GLOBAL_PAGEWRITER_STATUS
- GLOBAL_RECORD_RESET_TIME
- GLOBAL_REDO_STATUS
- GLOBAL_RECOVERY_STATUS
- CLASS_VITAL_INFO
- USER_LOGIN
- SUMMARY_USER_LOGIN
- GLOBAL_GET_BGWRITER_STATUS
- GLOBAL_SINGLE_FLUSH_DW_STATUS
- GLOBAL_CANDIDATE_STATUS
- Lock
- Wait Events
- Configuration
- Operator
- Workload Manager
- Global Plancache
- RTO
- DBE_PLDEBUGGER Schema
- Overview
- DBE_PLDEBUGGER.turn_on
- DBE_PLDEBUGGER.turn_off
- DBE_PLDEBUGGER.local_debug_server_info
- DBE_PLDEBUGGER.attach
- DBE_PLDEBUGGER.info_locals
- DBE_PLDEBUGGER.next
- DBE_PLDEBUGGER.continue
- DBE_PLDEBUGGER.abort
- DBE_PLDEBUGGER.print_var
- DBE_PLDEBUGGER.info_code
- DBE_PLDEBUGGER.step
- DBE_PLDEBUGGER.add_breakpoint
- DBE_PLDEBUGGER.delete_breakpoint
- DBE_PLDEBUGGER.info_breakpoints
- DBE_PLDEBUGGER.backtrace
- DBE_PLDEBUGGER.disable_breakpoint
- DBE_PLDEBUGGER.enable_breakpoint
- DBE_PLDEBUGGER.finish
- DBE_PLDEBUGGER.set_var
- DB4AI Schema
- DBE_PLDEVELOPER
- Tool Reference
- Tool Overview
- Client Tool
- Server Tools
- Tools Used in the Internal System
- Unified Database Management Tool
- FAQ
- Functions of MogDB Executable Scripts
- System Catalogs and Views Supported by gs_collector
- Error Code Reference
- Description of SQL Error Codes
- Third-Party Library Error Codes
- GAUSS-00001 - GAUSS-00100
- GAUSS-00101 - GAUSS-00200
- GAUSS 00201 - GAUSS 00300
- GAUSS 00301 - GAUSS 00400
- GAUSS 00401 - GAUSS 00500
- GAUSS 00501 - GAUSS 00600
- GAUSS 00601 - GAUSS 00700
- GAUSS 00701 - GAUSS 00800
- GAUSS 00801 - GAUSS 00900
- GAUSS 00901 - GAUSS 01000
- GAUSS 01001 - GAUSS 01100
- GAUSS 01101 - GAUSS 01200
- GAUSS 01201 - GAUSS 01300
- GAUSS 01301 - GAUSS 01400
- GAUSS 01401 - GAUSS 01500
- GAUSS 01501 - GAUSS 01600
- GAUSS 01601 - GAUSS 01700
- GAUSS 01701 - GAUSS 01800
- GAUSS 01801 - GAUSS 01900
- GAUSS 01901 - GAUSS 02000
- GAUSS 02001 - GAUSS 02100
- GAUSS 02101 - GAUSS 02200
- GAUSS 02201 - GAUSS 02300
- GAUSS 02301 - GAUSS 02400
- GAUSS 02401 - GAUSS 02500
- GAUSS 02501 - GAUSS 02600
- GAUSS 02601 - GAUSS 02700
- GAUSS 02701 - GAUSS 02800
- GAUSS 02801 - GAUSS 02900
- GAUSS 02901 - GAUSS 03000
- GAUSS 03001 - GAUSS 03100
- GAUSS 03101 - GAUSS 03200
- GAUSS 03201 - GAUSS 03300
- GAUSS 03301 - GAUSS 03400
- GAUSS 03401 - GAUSS 03500
- GAUSS 03501 - GAUSS 03600
- GAUSS 03601 - GAUSS 03700
- GAUSS 03701 - GAUSS 03800
- GAUSS 03801 - GAUSS 03900
- GAUSS 03901 - GAUSS 04000
- GAUSS 04001 - GAUSS 04100
- GAUSS 04101 - GAUSS 04200
- GAUSS 04201 - GAUSS 04300
- GAUSS 04301 - GAUSS 04400
- GAUSS 04401 - GAUSS 04500
- GAUSS 04501 - GAUSS 04600
- GAUSS 04601 - GAUSS 04700
- GAUSS 04701 - GAUSS 04800
- GAUSS 04801 - GAUSS 04900
- GAUSS 04901 - GAUSS 05000
- GAUSS 05001 - GAUSS 05100
- GAUSS 05101 - GAUSS 05200
- GAUSS 05201 - GAUSS 05300
- GAUSS 05301 - GAUSS 05400
- GAUSS 05401 - GAUSS 05500
- GAUSS 05501 - GAUSS 05600
- GAUSS 05601 - GAUSS 05700
- GAUSS 05701 - GAUSS 05800
- GAUSS 05801 - GAUSS 05900
- GAUSS 05901 - GAUSS 06000
- GAUSS 06001 - GAUSS 06100
- GAUSS 06101 - GAUSS 06200
- GAUSS 06201 - GAUSS 06300
- GAUSS 06301 - GAUSS 06400
- GAUSS 06401 - GAUSS 06500
- GAUSS 06501 - GAUSS 06600
- GAUSS 06601 - GAUSS 06700
- GAUSS 06701 - GAUSS 06800
- GAUSS 06801 - GAUSS 06900
- GAUSS 06901 - GAUSS 07000
- GAUSS 07001 - GAUSS 07100
- GAUSS 07101 - GAUSS 07200
- GAUSS 07201 - GAUSS 07300
- GAUSS 07301 - GAUSS 07400
- GAUSS 07401 - GAUSS 07480
- GAUSS 50000 - GAUSS 50999
- GAUSS 51000 - GAUSS 51999
- GAUSS 52000 - GAUSS 52999
- GAUSS 53000 - GAUSS 53799
- Error Log Reference
- System Catalogs and System Views
- Common Faults and Identification
- Common Fault Locating Methods
- Common Fault Locating Cases
- Core Fault Locating
- Permission/Session/Data Type Fault Location
- Service/High Availability/Concurrency Fault Location
- Standby Node in the Need Repair (WAL) State
- Service Startup Failure
- Primary Node Is Hung in Demoting During a Switchover
- "too many clients already" Is Reported or Threads Failed To Be Created in High Concurrency Scenarios
- Performance Deterioration Caused by Dirty Page Flushing Efficiency During TPCC High Concurrentcy Long Term Stable Running
- Table/Partition Table Fault Location
- File System/Disk/Memory Fault Location
- After You Run the du Command to Query Data File Size In the XFS File System, the Query Result Is Greater than the Actual File Size
- File Is Damaged in the XFS File System
- Insufficient Memory
- "Error:No space left on device" Is Displayed
- When the TPC-C is running and a disk to be injected is full, the TPC-C stops responding
- Disk Space Usage Reaches the Threshold and the Database Becomes Read-only
- SQL Fault Location
- Index Fault Location
- CM Two-Node Fault Location
- Source Code Parsing
- FAQs
- Glossary
- Communication Matrix
- Mogeaver
Other System Functions(1)
The MogDB built-in functions and operators are inherited from the open-source PG. For details about the following functions, see the official PG documents.
| _pg_char_max_length | _pg_char_octet_length | _pg_datetime_precision | _pg_expandarray | _pg_index_position | _pg_interval_type | _pg_numeric_precision |
|---|---|---|---|---|---|---|
| _pg_numeric_precision_radix | _pg_numeric_scale | _pg_truetypid | _pg_truetypmod | abbrev | abs | abstime |
| abstimeeq | abstimege | abstimegt | abstimein | abstimele | abstimelt | abstimene |
| abstimeout | abstimerecv | abstimesend | aclcontains | acldefault | aclexplode | aclinsert |
| aclitemeq | aclitemin | aclitemout | aclremove | acos | age | akeys |
| any_in | any_out | anyarray_in | anyarray_out | anyarray_recv | anyarray_send | anyelement_in |
| anyelement_out | anyenum_in | anyenum_out | anynonarray_in | anynonarray_out | anyrange_in | anyrange_out |
| anytextcat | area | areajoinsel | areasel | array_agg | array_agg_finalfn | array_agg_transfn |
| array_append | array_cat | array_dims | array_eq | array_fill | array_ge | array_gt |
| array_in | array_larger | array_le | array_length | array_lower | array_lt | array_ndims |
| array_ne | array_out | array_prepend | array_recv | array_send | array_smaller | array_to_json |
| array_to_string | array_typanalyze | array_upper | arraycontained | arraycontains | arraycontjoinsel | arraycontsel |
| arrayoverlap | ascii | asin | atan | atan2 | avals | avg |
| big5_to_euc_tw | big5_to_mic | big5_to_utf8 | bit | bit_and | bit_in | bit_length |
| bit_or | bit_out | bit_recv | bit_send | bitand | bitcat | bitcmp |
| biteq | bitge | bitgt | bitle | bitlt | bitne | bitnot |
| bitor | bitshiftleft | bitshiftright | bittypmodin | bittypmodout | bitxor | bool |
| bool_and | bool_or | booland_statefunc | booleq | boolge | boolgt | boolin |
| boolle | boollt | boolne | boolor_statefunc | boolout | boolrecv | boolsend |
| box | box_above | box_above_eq | box_add | box_below | box_below_eq | box_center |
| box_contain | box_contain_pt | box_contained | box_distance | box_div | box_eq | box_ge |
| box_gt | box_in | box_intersect | box_le | box_left | box_lt | box_mul |
| box_out | box_overabove | box_overbelow | box_overlap | box_overleft | box_overright | box_recv |
| box_right | box_same | box_send | box_sub | bpchar | bpchar_larger | bpchar_pattern_ge |
| bpchar_pattern_gt | bpchar_pattern_le | bpchar_pattern_lt | bpchar_smaller | bpchar_sortsupport | bpcharcmp | bpchareq |
| bpcharge | bpchargt | bpchariclike | bpcharicnlike | bpcharicregexeq | bpcharicregexne | bpcharin |
| bpcharle | bpcharlike | bpcharlt | bpcharne | bpcharnlike | bpcharout | bpcharrecv |
| bpcharregexeq | bpcharregexne | bpcharsend | bpchartypmodin | bpchartypmodout | broadcast | btabstimecmp |
| btarraycmp | btbeginscan | btboolcmp | btbpchar_pattern_cmp | btbuild | btbuildempty | btbulkdelete |
| btcanreturn | btcharcmp | btcostestimate | btendscan | btfloat48cmp | btfloat4cmp | btfloat4sortsupport |
| btfloat84cmp | btfloat8cmp | btfloat8sortsupport | btgetbitmap | btgettuple | btinsert | btint24cmp |
| btint28cmp | btint2cmp | btint2sortsupport | btint42cmp | btint48cmp | btint4cmp | btint4sortsupport |
| btint82cmp | btint84cmp | btint8cmp | btint8sortsupport | btmarkpos | btnamecmp | btnamesortsupport |
| btoidcmp | btoidsortsupport | btoidvectorcmp | btoptions | btrecordcmp | btreltimecmp | btrescan |
| btrestrpos | btrim | bttext_pattern_cmp | bttextcmp | bttextsortsupport | bttidcmp | bttintervalcmp |
| btvacuumcleanup | bytea_sortsupport | bytea_string_agg_finalfn | bytea_string_agg_transfn | byteacat | byteacmp | byteaeq |
| byteage | byteagt | byteain | byteale | bytealike | bytealt | byteane |
| byteanlike | byteaout | bytearecv | byteasend | cash_cmp | cash_div_cash | cash_div_flt4 |
| cash_div_flt8 | cash_div_int2 | cash_div_int4 | cash_div_int8 | cash_eq | cash_ge | cash_gt |
| cash_in | cash_le | cash_lt | cash_mi | cash_mul_flt4 | cash_mul_flt8 | cash_mul_int2 |
| cash_mul_int4 | cash_mul_int8 | cash_ne | cash_out | cash_pl | cash_recv | cash_send |
| cashlarger | cashsmaller | cbrt | ceil | ceiling | center | char |
| char_length | character_length | chareq | charge | chargt | charin | charle |
| charlt | charne | charout | charrecv | charsend | chr | cideq |
| cidin | cidout | cidr | cidr_in | cidr_out | cidr_recv | cidr_send |
| cidrecv | cidsend | circle | circle_above | circle_add_pt | circle_below | circle_center |
| circle_contain | circle_contain_pt | circle_contained | circle_distance | circle_div_pt | circle_eq | circle_ge |
| circle_gt | circle_in | circle_le | circle_left | circle_lt | circle_mul_pt | circle_ne |
| circle_out | circle_overabove | circle_overbelow | circle_overlap | circle_overleft | circle_overright | circle_recv |
| circle_right | circle_same | circle_send | circle_sub_pt | clock_timestamp | close_lb | close_ls |
| close_lseg | close_pb | close_pl | close_ps | close_sb | close_sl | col_description |
| concat | concat_ws | contjoinsel | contsel | convert | convert_from | convert_to |
| corr | cos | cot | count | covar_pop | covar_samp | cstring_in |
| cstring_out | cstring_recv | cstring_send | cume_dist | current_database | current_query | current_schema |
| xpath_exists | current_setting | current_user | currtid | currtid2 | currval | cursor_to_xml |
| cursor_to_xmlschema | database_to_xml | database_to_xml_and_xmlschema | database_to_xmlschema | date | date_cmp | date_cmp_timestamp |
| date_cmp_timestamptz | date_eq | date_eq_timestamp | date_eq_timestamptz | date_ge | date_ge_timestamp | date_ge_timestamptz |
| date_gt | date_gt_timestamp | date_gt_timestamptz | date_in | date_larger | date_le | date_le_timestamp |
| date_le_timestamptz | date_lt | date_lt_timestamp | date_lt_timestamptz | date_mi | date_mi_interval | date_mii |
| date_ne | date_ne_timestamp | date_ne_timestamptz | date_out | date_pl_interval | date_pli | date_recv |
| date_send | date_smaller | date_sortsupport | daterange_canonical | daterange_subdiff | datetime_pl | datetimetz_pl |
| dcbrt | decode | defined | degrees | delete | dense_rank | dexp |
| diagonal | diameter | dispell_init | dispell_lexize | dist_cpoly | dist_lb | dist_pb |
| dist_pc | dist_pl | dist_ppath | dist_ps | dist_sb | dist_sl | div |
| dlog1 | dlog10 | domain_in | domain_recv | dpow | dround | dsimple_init |
| dsimple_lexize | dsnowball_init | dsnowball_lexize | dsqrt | dsynonym_init | dsynonym_lexize | dtrunc |
| each | enum_ne | enum_out | enum_range | enum_recv | enum_send | enum_smaller |
| eqjoinsel | eqsel | euc_cn_to_mic | euc_cn_to_utf8 | euc_jis_2004_to_shift_jis_2004 | euc_jis_2004_to_utf8 | euc_jp_to_mic |
| euc_jp_to_sjis | euc_jp_to_utf8 | euc_kr_to_mic | euc_kr_to_utf8 | euc_tw_to_big5 | euc_tw_to_mic | euc_tw_to_utf8 |
| every | exist | exists_all | exists_any | exp | factorial | family |
| fdw_handler_in | fdw_handler_out | fetchval | first_value | float4 | float4_accum | float48div |
| float48eq | float48ge | float48gt | float48le | float48lt | float48mi | float48mul |
| float48ne | float48pl | float4abs | float4div | float4eq | float4ge | float4gt |
| float4in | float4larger | float4le | float4lt | float4mi | float4mul | float4ne |
| float4out | float4pl | float4recv | float4send | float4smaller | float4um | float4up |
| float8 | float8_accum | float8_avg | float8_collect | float8_corr | float8_covar_pop | float8_covar_samp |
| float8_regr_accum | float8_regr_avgx | float8_regr_avgy | float8_regr_collect | float8_regr_intercept | float8_regr_r2 | float8_regr_slope |
| float8_regr_sxx | float8_regr_sxy | float8_regr_syy | float8_stddev_pop | float8_stddev_samp | float8_var_pop | float8_var_samp |
| float84div | float84eq | float84ge | float84gt | float84le | float84lt | float84mi |
| float84mul | float84ne | float84pl | float8abs | float8div | float8eq | float8ge |
| float8gt | float8in | float8larger | float8le | float8lt | float8mi | float8mul |
| float8ne | float8out | float8pl | float8recv | float8send | float8smaller | float8um |
| float8up | floor | flt4_mul_cash | flt8_mul_cash | fmgr_c_validator | fmgr_internal_validator | fmgr_sql_validator |
| format | format_type | gb18030_to_utf8 | gbk_to_utf8 | generate_series | generate_subscripts | get_bit |
| get_byte | get_current_ts_config | - | - | gin_clean_pending_list | gin_cmp_prefix | gin_cmp_tslexeme |
| gin_extract_tsquery | gin_extract_tsvector | gin_tsquery_consistent | gin_tsquery_triconsistent | ginarrayconsistent | ginarrayextract | ginarraytriconsistent |
| ginbeginscan | ginbuild | ginbuildempty | ginbulkdelete | gincostestimate | ginendscan | gingetbitmap |
| gininsert | ginmarkpos | ginoptions | ginqueryarrayextract | ginrescan | ginrestrpos | ginvacuumcleanup |
| gist_box_compress | gist_box_consistent | gist_box_decompress | gist_box_penalty | gist_box_picksplit | gist_box_same | gist_box_union |
| gist_circle_compress | gist_circle_consistent | gist_point_compress | gist_point_consistent | gist_point_distance | gist_poly_compress | gist_poly_consistent |
| gistbeginscan | gistbuild | gistbuildempty | gistbulkdelete | gistcostestimate | gistendscan | gistgetbitmap |
| gistgettuple | gistinsert | gistmarkpos | gistoptions | gistrescan | gistrestrpos | gistvacuumcleanup |
| gtsquery_compress | gtsquery_consistent | gtsquery_decompress | gtsquery_penalty | gtsquery_picksplit | gtsquery_same | gtsquery_union |
| gtsvector_compress | gtsvector_consistent | gtsvector_decompress | gtsvector_penalty | gtsvector_picksplit | gtsvector_same | gtsvector_union |
| gtsvectorin | gtsvectorout | has_tablespace_privilege | has_type_privilege | hash_aclitem | hashbeginscan | hashbuild |
| hashbuildempty | hashbulkdelete | hashcostestimate | hashendscan | hashgetbitmap | hashgettuple | hashinsert |
| hashint2vector | hashint4 | hashint8 | hashmacaddr | hashmarkpos | hashname | hashoid |
| hashoidvector | hashoptions | hashrescan | hashrestrpos | hashtext | hashvacuumcleanup | hashvarlena |
| host | hostmask | iclikejoinsel | iclikesel | icnlikejoinsel | icnlikesel | icregexeqjoinsel |
| icregexeqsel | icregexnejoinsel | icregexnesel | inet_client_addr | inet_client_port | inet_in | inet_out |
| inet_recv | inet_send | inet_server_addr | inet_server_port | inetand | inetmi | inetmi_int8 |
| inetnot | inetor | inetpl | initcap | int2_accum | int2_avg_accum | int2_mul_cash |
| int2_sum | int24div | int24eq | int24ge | int24gt | int24le | int24lt |
| int24mi | int24mul | int24ne | int24pl | int28div | int28eq | int28ge |
| int28gt | int28le | int28lt | int28mi | int28mul | int28ne | int28pl |
| int2abs | int2and | int2div | int2eq | int2ge | int2gt | int2in |
| int2larger | int2le | int2lt | int2mi | int2mod | int2mul | int2ne |
| int2not | int2or | int2out | int2pl | int2recv | int2send | int2shl |
| int2shr | int2smaller | int2um | int2up | int2vectoreq | int2vectorin | int2vectorout |
| int2vectorrecv | int2vectorsend | int2xor | int4_accum | int4_avg_accum | int4_mul_cash | int4_sum |
| int42div | int42eq | int42ge | int42gt | int42le | int42lt | int42mi |
| int42mul | int42ne | int42pl | int48div | int48eq | int48ge | int48gt |
| int48le | int48lt | int48mi | int48mul | int48ne | int48pl | int4abs |
| int4and | int4div | int4eq | int4ge | int4gt | int4in | int4inc |
| int4larger | int4le | int4lt | int4mi | int4mod | int4mul | int4ne |
| int4not | int4or | int4out | int4pl | int4range | int4range_canonical | int4range_subdiff |
| int4recv | int4send | int4shl | int4shr | int4smaller | int4um | int4up |
| int4xor | int8 | int8_avg | int8_avg_accum | int8_avg_collect | int8_mul_cash | int8_sum |
| int8_sum_to_int8 | int8_accum | int82div | int82eq | int82ge | int82gt | int82le |
| int82lt | int82mi | int82mul | int82ne | int82pl | int84div | int84eq |
| int84ge | int84gt | int84le | int84lt | int84mi | int84mul | int84ne |
| int84pl | int8abs | int8and | int8div | int8eq | int8ge | int8gt |
| int8in | int8inc | int8inc_any | int8inc_float8_float8 | int8larger | int8le | int8lt |
| int8mi | int8mod | int8mul | int8ne | int8not | int8or | int8out |
| int8pl | int8pl_inet | int8range | int8range_canonical | int8range_subdiff | int8recv | int8send |
| int8shl | int8shr | int8smaller | int8um | int8up | int8xor | integer_pl_date |
| inter_lb | inter_sb | inter_sl | internal_in | internal_out | interval | interval_accum |
| interval_avg | interval_cmp | interval_collect | interval_div | interval_eq | interval_ge | interval_gt |
| interval_hash | interval_in | interval_larger | interval_le | interval_lt | interval_mi | interval_mul |
| interval_ne | interval_out | interval_pl | interval_pl_date | interval_pl_time | interval_pl_timestamp | interval_pl_timestamptz |
| interval_pl_timetz | interval_recv | interval_send | interval_smaller | interval_transform | interval_um | intervaltypmodin |
| intervaltypmodout | intinterval | isexists | ishorizontal | iso_to_koi8r | iso_to_mic | iso_to_win1251 |
| iso_to_win866 | iso8859_1_to_utf8 | iso8859_to_utf8 | isparallel | isperp | isvertical | johab_to_utf8 |
| jsonb_in | jsonb_out | jsonb_recv | jsonb_send | - | - | - |
| json_in | json_out | json_recv | json_send | justify_days | justify_hours | justify_interval |
| koi8r_to_iso | koi8r_to_mic | koi8r_to_utf8 | koi8r_to_win1251 | koi8r_to_win866 | koi8u_to_utf8 | language_handler_in |
| language_handler_out | latin1_to_mic | latin2_to_mic | latin2_to_win1250 | latin3_to_mic | latin4_to_mic | like_escape |
| likejoinsel | likesel | line | line_distance | line_eq | line_horizontal | line_in |
| line_interpt | line_intersect | line_out | line_parallel | line_perp | line_recv | line_send |
| line_vertical | ln | lo_close | lo_creat | lo_create | lo_export | lo_import |
| lo_lseek | lo_open | lo_tell | lo_truncate | lo_unlink | log | loread |
| lower | lower_inc | lower_inf | lowrite | lpad | lseg | lseg_center |
| lseg_distance | lseg_eq | lseg_ge | lseg_gt | lseg_horizontal | lseg_in | lseg_interpt |
| lseg_intersect | lseg_le | lseg_length | lseg_lt | lseg_ne | lseg_out | lseg_parallel |
| lseg_perp | lseg_recv | lseg_send | lseg_vertical | ltrim | macaddr_and | macaddr_cmp |
| macaddr_eq | macaddr_ge | macaddr_gt | macaddr_in | macaddr_le | macaddr_lt | macaddr_ne |
| macaddr_not | macaddr_or | macaddr_out | macaddr_recv | macaddr_send | makeaclitem | masklen |
| max | md5 | mic_to_big5 | mic_to_euc_cn | mic_to_euc_jp | mic_to_euc_kr | mic_to_euc_tw |
| mic_to_iso | mic_to_koi8r | mic_to_latin1 | mic_to_latin2 | mic_to_latin3 | mic_to_latin4 | mic_to_sjis |
| mic_to_win1250 | mic_to_win1251 | mic_to_win866 | min | mktinterval | money | mul_d_interval |
| name | nameeq | namege | namegt | nameiclike | nameicnlike | nameicregexeq |
| nameicregexne | namein | namele | namelike | namelt | namene | namenlike |
| nameout | namerecv | nameregexeq | nameregexne | namesend | neqjoinsel | neqsel |
| network_cmp | network_eq | network_ge | network_gt | network_le | network_lt | network_ne |
| network_sub | network_subeq | network_sup | network_supeq | nlikejoinsel | nlikesel | numeric |
| numeric_abs | numeric_accum | numeric_add | numeric_avg | numeric_avg_accum | numeric_avg_collect | numeric_cmp |
| numeric_collect | numeric_div | numeric_div_trunc | numeric_eq | numeric_exp | numeric_fac | numeric_ge |
| numeric_gt | numeric_in | numeric_inc | numeric_larger | numeric_le | numeric_ln | numeric_log |
| numeric_lt | numeric_mod | numeric_mul | numeric_ne | numeric_out | numeric_power | numeric_recv |
| numeric_send | numeric_smaller | numeric_sortsupport | numeric_sqrt | numeric_stddev_pop | numeric_stddev_samp | numeric_sub |
| numeric_transform | numeric_uminus | numeric_uplus | numeric_var_pop | numeric_var_samp | numerictypmodin | numerictypmodout |
| numrange_subdiff | oid | oideq | oidge | oidgt | oidin | oidlarger |
| oidle | oidlt | oidne | oidout | oidrecv | oidsend | oidsmaller |
| oidvectoreq | oidvectorge | oidvectorgt | oidvectorin | oidvectorle | oidvectorlt | oidvectorne |
| oidvectorout | oidvectorrecv | oidvectorsend | oidvectortypes | on_pb | on_pl | on_ppath |
| on_ps | on_sb | on_sl | opaque_in | opaque_out | ordered_set_transition | overlaps |
| overlay | path | path_add | path_add_pt | path_center | path_contain_pt | path_distance |
| path_div_pt | path_in | path_inter | path_length | path_mul_pt | path_n_eq | path_n_ge |
| path_n_gt | path_n_le | path_n_lt | path_npoints | path_out | path_recv | path_send |
| path_sub_pt | percentile_cont | percentile_cont_float8_final | percentile_cont_interval_final | pg_char_to_encoding | pg_cursor | pg_encoding_max_length |
| pg_encoding_to_char | pg_extension_config_dump | - | - | pg_node_tree_in | pg_node_tree_out | pg_node_tree_recv |
| pg_node_tree_send | pg_prepared_statement | pg_prepared_xact | - | - | pg_show_all_settings | pg_stat_get_bgwriter_stat_reset_time |
| pg_stat_get_buf_fsync_backend | pg_stat_get_checkpoint_sync_time | pg_stat_get_checkpoint_write_time | pg_stat_get_db_blk_read_time | pg_stat_get_db_blk_write_time | pg_stat_get_db_conflict_all | pg_stat_get_db_conflict_bufferpin |
| pg_stat_get_db_conflict_snapshot | pg_stat_get_db_conflict_startup_deadlock | pg_switch_xlog | xpath | pg_timezone_abbrevs | pg_timezone_names | pg_stat_get_wal_receiver |
| plpgsql_call_handler | plpgsql_inline_handler | plpgsql_validator | point_above | point_add | point_below | point_distance |
| point_div | point_eq | point_horiz | point_in | point_left | point_mul | point_ne |
| point_out | point_recv | point_right | point_send | point_sub | point_vert | poly_above |
| poly_below | poly_center | poly_contain | poly_contain_pt | poly_contained | poly_distance | poly_in |
| poly_left | poly_npoints | poly_out | poly_overabove | poly_overbelow | poly_overlap | poly_overleft |
| poly_overright | poly_recv | poly_right | poly_same | poly_send | polygon | position |
| positionjoinsel | positionsel | postgresql_fdw_validator | pow | power | prsd_end | prsd_headline |
| prsd_lextype | prsd_nexttoken | prsd_start | pt_contained_circle | pt_contained_poly | query_to_xml | query_to_xml_and_xmlschema |
| query_to_xmlschema | quote_ident | quote_literal | quote_nullable | radians | radius | random |
| range_adjacent | range_after | range_before | range_cmp | range_contained_by | range_contains | range_contains_elem |
| range_eq | range_ge | range_gist_compress | range_gist_consistent | range_gist_decompress | range_gist_penalty | range_gist_picksplit |
| range_gist_same | range_gist_union | range_gt | range_in | range_intersect | range_le | range_lt |
| range_minus | range_ne | range_out | range_overlaps | range_overleft | range_overright | range_recv |
| range_send | range_typanalyze | range_union | rank | record_eq | record_ge | record_gt |
| record_in | record_le | record_lt | record_ne | record_out | record_recv | record_send |
| regclass | regclassin | regclassout | regclassrecv | regclasssend | regconfigin | regconfigout |
| regconfigrecv | regconfigsend | regdictionaryin | regdictionaryout | regdictionaryrecv | regdictionarysend | regexeqjoinsel |
| regexeqsel | regexnejoinsel | regexnesel | regexp_matches | regexp_replace | regexp_split_to_array | regexp_split_to_table |
| regoperatorin | regoperatorout | regoperatorrecv | regoperatorsend | regoperin | regoperout | regoperrecv |
| regopersend | regprocedurein | regprocedureout | regprocedurerecv | regproceduresend | regprocin | regprocout |
| regprocrecv | regprocsend | regr_avgx | regr_avgy | regr_count | regr_intercept | regr_r2 |
| regr_slope | regr_sxx | regr_sxy | regr_syy | regtypein | regtypeout | regtyperecv |
| regtypesend | reltime | reltimeeq | reltimege | reltimegt | reltimein | reltimele |
| reltimelt | reltimene | reltimeout | reltimerecv | reltimesend | repeat | replace |
| reverse | RI_FKey_cascade_del | RI_FKey_cascade_upd | RI_FKey_check_ins | RI_FKey_check_upd | RI_FKey_noaction_del | RI_FKey_noaction_upd |
| RI_FKey_restrict_del | RI_FKey_restrict_upd | RI_FKey_setdefault_del | RI_FKey_setdefault_upd | RI_FKey_setnull_del | RI_FKey_setnull_upd | right |
| round | row_number | row_to_json | rpad | rtrim | scalargtjoinsel | scalargtsel |
| scalarltjoinsel | scalarltsel | schema_to_xml | schema_to_xml_and_xmlschema | schema_to_xmlschema | session_user | set_bit |
| set_byte | set_config | set_masklen | shift_jis_2004_to_euc_jis_2004 | shift_jis_2004_to_utf8 | sjis_to_euc_jp | sjis_to_mic |
| sjis_to_utf8 | smgrin | smgrout | spg_kd_choose | spg_kd_config | spg_kd_inner_consistent | spg_kd_picksplit |
| spg_quad_choose | spg_quad_config | spg_quad_inner_consistent | spg_quad_leaf_consistent | spg_quad_picksplit | spg_text_choose | spg_text_config |
| spg_text_inner_consistent | spg_text_leaf_consistent | spg_text_picksplit | spgbeginscan | spgbuild | spgbuildempty | spgbulkdelete |
| spgcanreturn | spgcostestimate | spgendscan | spggetbitmap | spggettuple | spginsert | spgmarkpos |
| spgoptions | spgrescan | spgrestrpos | spgvacuumcleanup | stddev | stddev_pop | stddev_samp |
| string_agg | string_agg_finalfn | string_agg_transfn | strip | sum | suppress_redundant_updates_trigger | table_to_xml |
| table_to_xml_and_xmlschema | table_to_xmlschema | tan | text | text_ge | text_gt | text_larger |
| text_le | text_lt | text_pattern_ge | text_pattern_gt | text_pattern_le | text_pattern_lt | text_smaller |
| textanycat | textcat | texteq | texticlike | texticnlike | texticregexeq | texticregexne |
| textin | textlike | textne | textnlike | textout | textrecv | textregexeq |
| textregexne | textsend | thesaurus_init | thesaurus_lexize | tideq | tidge | tidgt |
| tidin | tidlarger | tidle | tidlt | tidne | tidout | tidrecv |
| tidsend | tidsmaller | time | time_cmp | time_eq | time_ge | time_gt |
| time_hash | time_in | time_larger | time_le | time_lt | time_mi_interval | time_mi_time |
| time_ne | time_out | time_pl_interval | time_recv | time_send | time_smaller | time_transform |
| timedate_pl | timemi | timepl | timestamp | timestamp_cmp | timestamp_cmp_date | timestamp_cmp_timestamptz |
| timestamp_eq | timestamp_eq_date | timestamp_eq_timestamptz | timestamp_ge | timestamp_ge_date | timestamp_ge_timestamptz | timestamp_gt |
| timestamp_gt_date | timestamp_gt_timestamptz | timestamp_hash | timestamp_in | timestamp_larger | timestamp_le | timestamp_le_date |
| timestamp_le_timestamptz | timestamp_lt | timestamp_lt_date | timestamp_lt_timestamptz | timestamp_mi | timestamp_mi_interval | timestamp_ne |
| timestamp_ne_date | timestamp_ne_timestamptz | timestamp_out | timestamp_pl_interval | timestamp_recv | timestamp_send | timestamp_smaller |
| timestamp_sortsupport | timestamp_transform | timestamptypmodin | timestamptypmodout | timestamptz | timestamptz_cmp | timestamptz_cmp_date |
| timestamptz_cmp_timestamp | timestamptz_eq | timestamptz_eq_date | timestamptz_eq_timestamp | timestamptz_ge | timestamptz_ge_date | timestamptz_ge_timestamp |
| timestamptz_gt | timestamptz_gt_date | timestamptz_gt_timestamp | timestamptz_in | timestamptz_larger | timestamptz_le | timestamptz_le_date |
| timestamptz_le_timestamp | timestamptz_lt | timestamptz_lt_date | timestamptz_lt_timestamp | timestamptz_mi | timestamptz_mi_interval | timestamptz_ne |
| timestamptz_ne_date | timestamptz_ne_timestamp | timestamptz_out | timestamptz_pl_interval | timestamptz_recv | timestamptz_send | timestamptz_smaller |
| timestamptztypmodin | timestamptztypmodout | timetypmodin | timetypmodout | timetz | timetz_cmp | timetz_eq |
| timetz_ge | timetz_gt | timetz_hash | timetz_in | timetz_larger | timetz_le | timetz_lt |
| timetz_mi_interval | timetz_ne | timetz_out | timetz_pl_interval | timetz_recv | timetz_send | timetz_smaller |
| timetzdate_pl | timetztypmodin | timetztypmodout | timezone (2069) | timezone (1159) | timezone (2037) | timezone (2070) |
| timezone (1026) | timezone (2038) | tintervalct | tintervaleq | tintervalge | tintervalgt | tintervalin |
| tintervalle | tintervalleneq | tintervallenge | tintervallengt | tintervallenle | tintervallenlt | tintervallenne |
| tintervallt | tintervalne | tintervalout | tintervalov | tintervalrecv | tintervalsame | tintervalsend |
| tintervalstart | to_ascii (1845) | to_ascii (1847) | to_ascii (1846) | trigger_in | trigger_out | ts_match_qv |
| ts_match_tq | ts_match_tt | ts_match_vq | ts_rank | ts_rank_cd | ts_rewrite | ts_stat |
| ts_token_type | ts_typanalyze | tsmatchjoinsel | tsmatchsel | tsq_mcontained | tsq_mcontains | tsquery_and |
| tsquery_cmp | tsquery_eq | tsquery_ge | tsquery_gt | tsquery_le | tsquery_lt | tsquery_ne |
| tsquery_not | tsquery_or | tsqueryin | tsqueryout | tsqueryrecv | tsquerysend | tsrange |
| tsrange_subdiff | tstzrange | tstzrange_subdiff | tsvector_cmp | tsvector_concat | tsvector_eq | tsvector_ge |
| tsvector_gt | tsvector_le | tsvector_lt | tsvector_ne | tsvector_update_trigger | tsvector_update_trigger_column | tsvectorin |
| tsvectorout | tsvectorrecv | tsvectorsend | txid_current | txid_current_snapshot | txid_snapshot_in | txid_snapshot_out |
| txid_snapshot_recv | txid_snapshot_send | txid_snapshot_xip | txid_snapshot_xmax | txid_snapshot_xmin | txid_visible_in_snapshot | uhc_to_utf8 |
| unique_key_recheck | unknownin | unknownout | unknownrecv | unknownsend | unnest | utf8_to_big5 |
| utf8_to_euc_cn | utf8_to_euc_jis_2004 | utf8_to_euc_jp | utf8_to_euc_kr | utf8_to_euc_tw | utf8_to_gb18030 | utf8_to_gbk |
| utf8_to_iso8859 | utf8_to_iso8859_1 | utf8_to_johab | utf8_to_koi8r | utf8_to_koi8u | utf8_to_shift_jis_2004 | utf8_to_sjis |
| utf8_to_uhc | utf8_to_win | uuid_cmp | uuid_eq | uuid_ge | uuid_gt | uuid_hash |
| uuid_in | uuid_le | uuid_lt | uuid_ne | uuid_out | uuid_recv | uuid_send |
| var_pop | var_samp | varbit | varbit_in | varbit_out | varbit_recv | varbit_send |
| varbit_transform | varbitcmp | varbiteq | varbitge | varbitgt | varbitle | varbitlt |
| varbitne | varbittypmodin | varbittypmodout | varchar | varchar_transform | varcharin | varcharout |
| varcharrecv | varcharsend | varchartypmodin | varchartypmodout | variance | void_in | void_out |
| void_recv | void_send | win_to_utf8 | win1250_to_latin2 | win1250_to_mic | win1251_to_iso | win1251_to_koi8r |
| win1251_to_mic | win1251_to_win866 | win866_to_iso | win866_to_koi8r | win866_to_mic | win866_to_win1251 | xideq |
| xideqint4 | xidin | xidout | xidrecv | xidsend | xml | xml_in |
| xml_is_well_formed | xml_is_well_formed_content | xml_is_well_formed_document | xml_out | xml_recv | xml_send | xmlagg |
| xmlcomment | xmlconcat2 | xmlexists | xmlvalidate | pg_notify | - | - |