PostgreSQL 在线MPP数据仓库服务 简单易用、海量扩展、兼容部分Oracle 语法生态、既支持在线交互分析，也支持离线数据处理。 AnalyticDB for PostgreSQL （云Greenplum）低成本，快速 构筑在线企业数据仓库。 • 应用易开发、适配 支持SQL 2003，部分兼容Oracle语法， 支持PL/SQL 存储过程，OLAP窗口函数，事务及数据库标准隔离级别 完备功能和生态，实现应用快速迁移或适配 新一代SQL优化器，实现复杂分析语句免调优 • 支持多模分析 通过PostGIS 插件支持 地理信息数据分析；MADlib 库内置100+ 机器学习算法库，实现数据智能探索；高性 能向量检索算法，支持视频/图像检索 以图搜图 AnalyticDB for PostgreSQL 产品架构 协调节点 OSS 分布式云存储服务 SQL Client/BI Tools 协调节点（Master Node） • 接收请求，制定分布式执行计划 定期自动备份 OSS • 数据并行加载 • 水平扩展：Share-Nothing 架构水平扩展，海量数据在线分析 • 行/列存储模型：行存储支持高并发在线分析，列存储支持全表数据高性能关联聚合 • 高可靠架构：支持分布式事务及ACID，双副本、主备切换透明，支持服务高可用 分 区 分 区 分 区 分 区 计算组 分 区 分 区 分 区 分 区 计算组 分 区 分 区 分 区

会被 消费，即在未来的调用中还会返回这些改变。 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 使用限制 目前不支持DDL的解析, 只有DML的解析 如：create，drop TEMPORARY表和UNLOGGED表不会被复制 表必须有主键或者唯一约束，否则像update或 者delete这样的操作无法被复制

pg_size_pre�y(pg_rela�on_size('table_name')); #以方便阅读的单位列 出表的大小 ★不建议使用带\反斜杠的内置命令，有些sql终端工具不支持发送带有\反斜杠 的命令 ★第7章、表 字段操作 ★第8章、表 数据操作 db_test=# \d tablexx;

Functions and Operators Function Return Type Description Example Result con- vert(string bytea, sr- c_encoding name, dest_encod- ing name) bytea Convert string to dest_encod- ing. The original encoding 'LATIN1') text_in_utf8 represented in Latin-1 encoding (ISO 8859-1) con- vert_from(string bytea, sr- c_encoding name) text Convert string to the data- base encoding. The original encod- ing is specified temporary boolean]) (slot_name name, lsn pg_lsn) Copies an existing physical replication slot named sr- c_slot_name to a physical replication slot named dst_s- lot_name. The copied physi- cal slot starts

guments are ig- nored. con- cat_ws(',', 'abcde', 2, NULL, 22) abcde,2,22 con- vert(string bytea, sr- c_encoding name, dest_encod- ing name) bytea Convert string to dest_encod- ing. The original encoding 'LATIN1') text_in_utf8 represented in Latin-1 encoding (ISO 8859-1) con- vert_from(string bytea, sr- c_encoding name) text Convert string to the data- base encoding. The original encod- ing is specified LATIN9 ISO 8859-15 LATIN1 with Euro and accents Yes Yes 1 ISO885915 LATIN10 ISO 8859-16, ASRO SR 14111 Romanian Yes No 1 ISO885916 MULE_IN- TERNAL Mule inter- nal code Multilingual Emacs Yes

guments are ig- nored. con- cat_ws(',', 'abcde', 2, NULL, 22) abcde,2,22 con- vert(string bytea, sr- c_encoding name, dest_encod- ing name) bytea Convert string to dest_encod- ing. The original encoding Description Example Result ble 9.10 for avail- able conversions. con- vert_from(string bytea, sr- c_encoding name) text Convert string to the data- base encoding. The original encod- ing is specified LATIN9 ISO 8859-15 LATIN1 with Euro and accents Yes Yes 1 ISO885915 LATIN10 ISO 8859-16, ASRO SR 14111 Romanian Yes No 1 ISO885916 MULE_IN- TERNAL Mule inter- nal code Multilingual Emacs Yes

arguments are ignored. con- cat_ws(',', 'abcde', 2, NULL, 22) abcde,2,22 con- vert(string bytea, sr- c_encoding name, dest_encoding name) bytea Convert string to dest_encod- ing. The original encoding 'LATIN1') text_in_utf8 represented in Latin-1 encoding (ISO 8859-1) con- vert_from(string bytea, sr- c_encoding name) text Convert string to the database encod- ing. The original encoding is speci- boolean]) (slot_name name, lsn pg_lsn) Copies an existing physical replication slot named sr- c_slot_name to a physical replication slot named dst_s- lot_name. The copied physical slot starts

arguments are ignored. con- cat_ws(',', 'abcde', 2, NULL, 22) abcde,2,22 con- vert(string bytea, sr- c_encoding bytea Convert string to dest_encod- ing. The original encoding is speci- convert('tex- predefined conver- sions. See Ta- ble 9.10 for avail- able conversions. con- vert_from(string bytea, sr- c_encoding name) text Convert string to the database encod- ing. The original encoding is speci- LATIN9 ISO 8859-15 LATIN1 with Euro and ac- cents Yes Yes 1 ISO885915 LATIN10 ISO 8859-16, ASRO SR 14111 Romanian Yes No 1 ISO885916 MULE_IN- TERNAL Mule internal code Multilingual Emacs Yes No

Function Return Type Description Example Result NULL arguments are ignored. con- vert(string bytea, sr- c_encoding name, dest_encoding name) bytea Convert string to dest_encod- ing. The original encoding 'LATIN1') text_in_utf8 represented in Latin-1 encoding (ISO 8859-1) con- vert_from(string bytea, sr- c_encoding name) text Convert string to the database encod- ing. The original encoding is speci- LATIN9 ISO 8859-15 LATIN1 with Euro and ac- cents Yes Yes 1 ISO885915 LATIN10 ISO 8859-16, ASRO SR 14111 Romanian Yes No 1 ISO885916 MULE_IN- TERNAL Mule internal code Multilingual Emacs Yes No

ISO 8859-14 (Latin alphabet no.8) LATIN9 ISO 8859-15 (Latin alphabet no.9) LATIN10 ISO 8859-16/ASRO SR 14111 (Latin alphabet no.10) ISO_8859_5 ISO 8859-5/ECMA 113 (Latin/Cyrillic) ISO_8859_6 ISO 8859-6/ECMA