云数据库 GAUSSDB-CREATE FOREIGN TABLE (导入导出):语法格式

时间:2024-11-02 18:48:27

语法格式

1
2
3
4
5
6
7
8
9
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/distributed-devg-v2-gaussdb/gaussdb_v5r2c10_0503.html