psql表删除字段

# 删除字段
alter table open.t_pay drop column f_reserve_int_1;
# 删除外表字段
ALTER external TABLE pay_data_ext.r_ext_t_pay DROP COLUMN f_reserve_int_1;

# 修改外表字段类型
ALTER external TABLE pay_data_ext.r_ext_t_pay ALTER f_client_ip TYPE bigint;
ALTER external TABLE open.r_ext_bi_data_info ALTER fr TYPE character varying(1024);
# 修改主表字段类型
alter table fn.t_reserve_bank_account_channel_details alter COLUMN f_org_code_ext type text;
alter table open.t_pay alter COLUMN f_client_ip type bigint;
ALTER TABLE open.bi_data_info ALTER fr TYPE character varying(1024);