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

时间：2023-11-01 16:22:51

云数据库 GaussDB

语法格式

  
       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 [, ... ] ) } ];