跳到主要内容
版本:v4.13

DML说明

作为数据目的地,支持的加载方式有insert,update,delete,ignore,merge

DML类型语法使用限制
Insertcopy:copy语法参考
plain COPY table_name [ ( column_name [, ...] ) ] FROM STDIN [ [ WITH ] ( option [, ...] ) ]
+ 无论目的地是否指定了逻辑主键,皆可以使用。
+ 写入数据中如果包含二进制数据,会被转为base64或者hex格式写入,可以通过页面配置。
UpdateUpdate:
plain UPDATE <table> [ * ] [ [ AS ] <alias> ] SET { <column> = { <expression> } \| ( <column> [, ...] ) = ( { <expression> } [, ...] ) } [, ...] [ FROM <from_list> ] [ WHERE <condition> ]
需要指定逻辑主键。
且不支持Update Distribution Key
Deletesql DELETE FROM <table_name> [ * ] [ [ AS ] <alias> ] [ WHERE <condition> ] 需要指定逻辑主键
Mergeinsert on conflct(upsert):
sql INSERT INTO <table_name> [ AS <alias> ] [ ( <column_name> [, ...] ) ] { VALUES ( { <expression> } [, ...] ) [, ...] \| <query> } [ ON CONFLICT [ conflict_target ] conflict_action ] where conflict_target is pk ON CONSTRAINT constraint_name and conflict_action is one of: DO NOTHING DO UPDATE SET { <column_name> = { <expression> } \| ( <column_name> [, ...] ) = ( { <expression> } [, ...] ) \| } [, ...] [ WHERE condition ]
要求必须包含主键
Ingore无要求