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

时间：2024-01-23 20:09:08

云数据库 GAUSSDB

语法格式

  
       CREATE FOREIGN TABLE [ IF NOT EXISTS ] table_name 
    ( [ { column_name type_name POSITION ( offset, length ) | LIKE source_table } [, ...] ] ) 
    SERVER server_name 
    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 [, ... ] ) } ];