数据仓库服务 GAUSSDB(DWS)-CREATE FOREIGN TABLE (OBS导入导出):语法格式

时间:2024-05-22 15:13:27

语法格式

1
2
3
4
5
6
7
8
CREATE FOREIGN TABLE [ IF NOT EXISTS  ] table_name 
( { column_name type_name [column_constraint ]
    | LIKE source_table | table_constraint [, ...]} [, ...] ) 
SERVER server_name
OPTIONS (  { option_name ' value '  }  [, ...] ) 
[  { WRITE ONLY  |  READ ONLY  }] 
[ WITH error_table_name | LOG INTO error_table_name] 
[PER NODE REJECT LIMIT 'value']  ;
support.huaweicloud.com/sqlreference-830-dws/dws_06_0160.html