App把图片或者视频等非结构化数据 通过特征提取服务，提取特征向量，并写入 AnalyticDB for PG的向量表。 2、Web App检索的时，把非结构化数据通过 特征提取服务接口提取出向量，同时调用 AnalyticDB for PG的查询分析接口做查询。 特点： • 易用，结构化和非结构化数据关联查询。 • 准确性高，阿里自研向量检索算法。 Web APP AnalyticDB for PostgreSQL

的场景定义不同的输出规则。也可以在相同的场景定 义不同的规则 2016Postgres中国用户大会 Postgres Conference China 2016 中国用户大会 自动导出快照 当使用流复制接口创建一个新的复制槽时， 将会自动产生一个快照。 无DB限制 Pg的逻辑复制可以根据需求把WAL日志直接翻译成 可以直接解析的SQL语句，并通过槽技术向不同DB 进行传递，从而实现不同DB数据库的复制。

.....................................................................................612 36.4.5. RENAME................................................................................................. constraints, • Remove constraints, • Change default values, • Change column data types, • Rename columns, • Rename tables. All these actions are performed using the ALTER TABLE command. 5.5.1. Adding a Renaming a Column To rename a column: ALTER TABLE products RENAME COLUMN product_no TO product_number; 5.5.8. Renaming a Table To rename a table: ALTER TABLE products RENAME TO items; 53 Chapter

.....................................................................................609 36.4.5. RENAME................................................................................................. constraints, • Remove constraints, • Change default values, • Change column data types, • Rename columns, • Rename tables. All these actions are performed using the ALTER TABLE command. 5.5.1. Adding a Renaming a Column To rename a column: ALTER TABLE products RENAME COLUMN product_no TO product_number; 5.5.8. Renaming a Table To rename a table: ALTER TABLE products RENAME TO items; 53 Chapter

.....................................................................................569 35.4.5. RENAME................................................................................................. constraints, • Remove constraints, • Change default values, • Change column data types, • Rename columns, • Rename tables. All these actions are performed using the ALTER TABLE command. 5.6.1. Adding a Column To rename a column: ALTER TABLE products RENAME COLUMN product_no TO product_number; 55 Chapter 5. Data Definition 5.6.8. Renaming a Table To rename a table: ALTER TABLE products RENAME TO items;

.....................................................................................538 35.4.5. RENAME................................................................................................. constraints, • Remove constraints, • Change default values, • Change column data types, • Rename columns, • Rename tables. All these actions are performed using the ALTER TABLE command. 50 Chapter 5. Column To rename a column: ALTER TABLE products RENAME COLUMN product_no TO product_number; 52 Chapter 5. Data Definition 5.6.8. Renaming a Table To rename a table: ALTER TABLE products RENAME TO items;

.....................................................................................772 38.3.5. RENAME................................................................................................. constraints, • Remove constraints, • Change default values, • Change column data types, • Rename columns, • Rename tables. All these actions are performed using the ALTER TABLE command, whose reference Column To rename a column: ALTER TABLE products RENAME COLUMN product_no TO product_number; 54 Chapter 5. Data Definition 5.5.8. Renaming a Table To rename a table: ALTER TABLE products RENAME TO items;

constraints • Remove constraints • Change default values • Change column data types • Rename columns • Rename tables All these actions are performed using the ALTER TABLE command, whose reference page Renaming a Column To rename a column: ALTER TABLE products RENAME COLUMN product_no TO product_number; 5.5.8. Renaming a Table To rename a table: ALTER TABLE products RENAME TO items; 5.6. Privileges modification (e.g., SELECT, UPDATE, DELETE, most variants of ALTER TABLE, but not INSERT or ALTER TABLE ... RENAME) typically default to including child tables and support the ONLY notation to exclude them. Commands

.....................................................................................729 38.3.5. RENAME................................................................................................. constraints, • Remove constraints, • Change default values, • Change column data types, • Rename columns, • Rename tables. All these actions are performed using the ALTER TABLE command, whose reference Renaming a Column To rename a column: ALTER TABLE products RENAME COLUMN product_no TO product_number; 5.5.8. Renaming a Table To rename a table: ALTER TABLE products RENAME TO items; 5.6. Privileges

constraints • Remove constraints • Change default values • Change column data types • Rename columns • Rename tables All these actions are performed using the ALTER TABLE command, whose reference page Renaming a Column To rename a column: ALTER TABLE products RENAME COLUMN product_no TO product_number; 5.5.8. Renaming a Table To rename a table: ALTER TABLE products RENAME TO items; 61 Chapter modification (e.g., SELECT, UPDATE, DELETE, most variants of ALTER TABLE, but not INSERT or ALTER TABLE ... RENAME) typically default to including child tables and support the ONLY notation to exclude them. Commands