PostgreSQL外部表

-- 方式一
create external table ext.r_ext_t_pay (like open.t_pay)
location ('gpfdist://*.*.*.*:****/open/t_pay')
format 'TEXT' (delimiter as E'\t' null as '\N' escape 'OFF');
-- 方式二
create external table ext.r_ext_t_pay (
    f_id bigint DEFAULT 1 NOT NULL,
    f_name varchar(20) DEFAULT '' NOT NULL
)
location ('gpfdist://*.*.*.*:****/open/t_pay')
format 'TEXT' (delimiter as E'\t' null as '\N' escape 'OFF');
-- 删除外表
drop external table ext.r_ext_t_pay;