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

时间:2025-02-12 15:04:42

语法格式

123456789
CREATE FOREIGN TABLE [ IF NOT EXISTS  ] table_name     ( [  { column_name type_name POSITION(offset,length) | LIKE source_table } [, ...]  ] )     SERVER gsmpp_server     OPTIONS (  { option_name ' value '  }  [, ...] )     [  { WRITE ONLY  |  READ ONLY  }]     [ WITH error_table_name |  LOG  INTO error_table_name]     [REMOTE LOG 'name']     [PER NODE REJECT LIMIT 'value']    [ TO { GROUP groupname | NODE ( nodename [, ... ] ) } ];
support.huaweicloud.com/sqlreference-910-dws/dws_06_0159.html