v5.0
- 关于MogDB
- 快速入门
- 特性描述
- 概览
- 高性能
- 高可用
- 维护性
- 兼容性
- 视图增加%rowtype属性
- 聚合函数distinct性能优化
- 聚合函数支持KEEP子句
- 聚合函数支持场景扩展
- 兼容支持MySQL别名支持单引号
- 支持current_date/current_time关键字作为字段名
- 自定义type数组
- For Update支持外连接
- MogDB支持Insert All特性
- Oracle DBLink语法兼容
- 创建PACKAGE/FUNCTION/PROCEDURE时去除TYPE类型转换提示
- 支持MERGE INTO命中索引时使用Bypass方法
- 支持增加存储过程及函数参数的nocopy属性
- 支持在数组extend的参数中传入数组的count属性
- 支持q quote转义字符
- 支持两个date类型的数据相减返回numeric类型
- 支持表函数table()
- 支持PROCEDURE/FUNCTION/PACKAGE的end后的name和Oracle保持一致
- 支持WHERE CURRENT OF写法
- 支持包内常量作为函数或者过程入参的默认值
- 支持PLPGSQL subtype
- 支持无参数FUNCTION的同义词调用不加括号
- 支持dbms_utility.format_error_backtrace
- 支持PIVOT和UNPIVOT语法
- mod函数兼容
- 支持聚集函数嵌套
- ORDER BY/GROUP BY场景兼容
- 支持在建表后修改表日志属性
- INSERT支持ON CONFLICT子句
- 支持AUTHID CURRENT_USER
- PBE模式支持存储过程out出参
- 数据库安全
- 企业级特性
- 应用开发接口
- AI能力
- 中间件
- 负载管理
- 安装指南
- 升级指南
- 管理指南
- 高可用指南
- AI特性指南
- 安全指南
- 开发者指南
- 应用程序开发教程
- 开发规范
- 基于JDBC开发
- JDBC包、驱动类和环境类
- 开发流程
- 加载驱动
- 连接数据库
- 连接数据库(以SSL方式)
- 连接数据库(UDS方式)
- 执行SQL语句
- 处理结果集
- 关闭连接
- 日志管理
- 示例:常用操作
- 示例:重新执行应用SQL
- 示例:通过本地文件导入导出数据
- 示例:从MY向MogDB进行数据迁移
- 示例:逻辑复制代码示例
- 示例:不同场景下连接数据库参数配置
- 示例:jdbc主备集群负载均衡
- JDBC接口参考
- 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常用参数参考
- JDBC发布记录
- 基于ODBC开发
- 基于libpq开发
- 基于Psycopg2开发
- 调试
- 存储过程
- 用户自定义函数
- PL/pgSQL-SQL过程语言
- 定时任务
- 自治事务
- 逻辑复制
- Extension
- MySQL兼容性说明
- Dolphin Extension
- Dolphin概述
- Dolphin安装
- Dolphin限制
- Dolphin语法介绍
- SQL参考
- 关键字
- 数据类型
- 函数和操作符
- 表达式
- DDL语法一览表
- DML语法一览表
- DCL语法一览表
- SQL语法
- ALTER DATABASE
- ALTER FUNCTION
- ALTER PROCEDURE
- ALTER SERVER
- ALTER TABLE
- ALTER TABLE PARTITION
- ALTER TABLESPACE
- ALTER VIEW
- ANALYZE | ANALYSE
- AST
- CHECKSUM TABLE
- CREATE DATABASE
- CREATE FUNCTION
- CREATE INDEX
- CREATE PROCEDURE
- CREATE SERVER
- CREATE TABLE
- CREATE TABLE AS
- CREATE TABLE PARTITION
- CREATE TABLESPACE
- CREATE TRIGGER
- CREATE VIEW
- DESCRIBE TABLE
- DO
- DROP DATABASE
- DROP INDEX
- DROP TABLESPACE
- EXECUTE
- EXPLAIN
- FLUSH BINARY LOGS
- GRANT
- GRANT/REVOKE PROXY
- INSERT
- KILL
- LOAD DATA
- OPTIMIZE TABLE
- PREPARE
- RENAME TABLE
- RENAME USER
- REVOKE
- SELECT
- SELECT HINT
- SET CHARSET
- SET PASSWORD
- SHOW CHARACTER SET
- SHOW COLLATION
- SHOW COLUMNS
- SHOW CREATE DATABASE
- SHOW CREATE FUNCTION
- SHOW CREATE PROCEDURE
- SHOW CREATE TABLE
- SHOW CREATE TRIGGER
- SHOW CREATE VIEW
- SHOW DATABASES
- SHOW FUNCTION STATUS
- SHOW GRANTS
- SHOW INDEX
- SHOW MASTER STATUS
- SHOW PLUGINS
- SHOW PRIVILEGES
- SHOW PROCEDURE STATUS
- SHOW PROCESSLIST
- SHOW SLAVE HOSTS
- SHOW STATUS
- SHOW TABLES
- SHOW TABLE STATUS
- SHOW TRIGGERS
- SHOW VARIABLES
- SHOW WARNINGS/ERRORS
- UPDATE
- USE db_name
- 系统视图
- GUC参数说明
- 重设参数
- 存储过程
- 标识符说明
- SQL参考
- MySQL语法兼容性评估工具
- Dolphin Extension
- 物化视图
- 分区管理
- 应用程序开发教程
- 性能优化指南
- 参考指南
- 系统表及系统视图
- 系统表和系统视图概述
- 查看系统表
- 系统表
- 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_EVENT_TRIGGER
- 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_SUBSCRIPTION_REL
- 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
- 系统视图
- GET_GLOBAL_PREPARED_XACTS(废弃)
- GS_ASYNC_SUBMIT_SESSIONS_STATUS
- GS_AUDITING
- GS_AUDITING_ACCESS
- GS_AUDITING_PRIVILEGE
- 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_SHARED_MEMORY_DETAIL
- 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
- IOS_STATUS
- 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
- PATCH_INFORMATION_TABLE
- 系统函数
- 逻辑操作符
- 比较操作符
- 字符处理函数和操作符
- 二进制字符串函数和操作符
- 位串函数和操作符
- 模式匹配操作符
- 数字操作函数和操作符
- 时间和日期处理函数和操作符
- 类型转换函数
- 几何函数和操作符
- 网络地址函数和操作符
- 文本检索函数和操作符
- JSON/JSONB函数和操作符
- HLL函数和操作符
- SEQUENCE函数
- 数组函数和操作符
- 范围函数和操作符
- 聚集函数
- 窗口函数(分析函数)
- 安全函数
- 账本数据库的函数
- 密态等值的函数
- 返回集合的函数
- 条件表达式函数
- 系统信息函数
- 系统管理函数
- 统计信息函数
- 触发器函数
- 事件触发器函数
- HashFunc函数
- 提示信息函数
- 全局临时表函数
- 故障注入系统函数
- AI特性函数
- 动态数据脱敏函数
- 其他系统函数
- 内部函数
- Global SysCache特性函数
- 数据损坏检测修复函数
- XML类型函数
- 废弃函数
- 支持的数据类型
- SQL语法
- ABORT
- ALTER AGGREGATE
- ALTER AUDIT POLICY
- ALTER DATABASE
- ALTER DATA SOURCE
- ALTER DEFAULT PRIVILEGES
- ALTER DIRECTORY
- ALTER EVENT
- ALTER EVENT TRIGGER
- ALTER EXTENSION
- ALTER FOREIGN DATA WRAPPER
- ALTER FOREIGN TABLE
- ALTER FUNCTION
- ALTER GLOBAL CONFIGURATION
- ALTER GROUP
- ALTER INDEX
- ALTER LANGUAGE
- ALTER LARGE OBJECT
- ALTER MASKING POLICY
- ALTER MATERIALIZED VIEW
- ALTER OPERATOR
- 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 EVENT
- CREATE EVENT TRIGGER
- CREATE EXTENSION
- CREATE FOREIGN DATA WRAPPER
- 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 TABLESPACE
- CREATE TABLE SUBPARTITION
- 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
- DELIMITER
- DO
- DROP AGGREGATE
- DROP AUDIT POLICY
- DROP CAST
- DROP CLIENT MASTER KEY
- DROP COLUMN ENCRYPTION KEY
- DROP DATABASE
- DROP DATA SOURCE
- DROP DIRECTORY
- DROP EVENT
- DROP EVENT TRIGGER
- DROP EXTENSION
- DROP FOREIGN DATA WRAPPER
- 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
- SHOW EVENTS
- SHRINK
- SHUTDOWN
- SNAPSHOT
- START TRANSACTION
- TIMECAPSULE TABLE
- TRUNCATE
- UPDATE
- VACUUM
- VALUES
- SQL参考
- GUC参数说明
- Schema
- Information Schema
- DBE_PERF
- 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
- 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
- DBE_SQL_UTIL Schema
- 工具参考
- 工具一览表
- 客户端工具
- 服务端工具
- 系统内部使用的工具
- dsscmd
- dssserver
- mogdb
- gs_backup
- gs_basebackup
- gs_ctl
- gs_initdb
- gs_install
- gs_postuninstall
- gs_preinstall
- gs_sshexkey
- gs_tar
- gs_uninstall
- gs_upgradectl
- gs_expansion
- gs_dropnode
- gs_probackup
- gstrace
- kdb5_util
- kadmin.local
- kinit
- klist
- krb5kdc
- kdestroy
- pg_config
- pg_controldata
- pg_recvlogical
- pg_resetxlog
- pg_archivecleanup
- pssh
- pscp
- transfer.py
- FAQ
- MogDB可运行脚本功能说明
- gs_collector工具支持收集的系统表和视图列表
- 数据库报错信息
- SQL标准错误码说明
- 第三方库错误码说明
- 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 07500
- GAUSS 50000 - GAUSS 50999
- GAUSS 51000 - GAUSS 51999
- GAUSS 52000 - GAUSS 52999
- GAUSS 53000 - GAUSS 53699
- 错误日志信息参考
- 系统表及系统视图
- 故障诊断指南
- 源码解析
- 常见问题解答 (FAQs)
- 术语表
- 通信矩阵
- Mogeaver
其他系统函数(一)
MogDB的内建函数和操作符继承自开源PG,下述函数不作赘述,详情请参见PG官方文档。
_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 | - | - |