1、varchar 类型转换成数字
select sum(CAST(order_num AS NUMERIC))
from ads_port_cli_cons_freq_rpt
where yr='2023' and mon = '08'
2、Postgresql类型转换用法介绍
Postgresql类型转换用法介绍_笔记大全_设计学院https://www.python100.com/html/B7S270Y24ZPR.html
3、Postgresql 字段备注
CREATE TABLE ads_fin_yjmxb_final_guangxi_gngj(
etl_time VARCHAR(256) ,
g_opecenter VARCHAR(256) ,
g_period VARCHAR(256) ,
g_inter_or_dom VARCHAR(256) ,
g_inter_or_dom_fenkaitongji VARCHAR(256) ,
g_inter_or_dom_tatal VARCHAR(256) ,
g_zb_gngj VARCHAR(256)
)
-- 添加注释到表
COMMENT ON TABLE ads_fin_yjmxb_final_guangxi_gngj IS '广西_国际国内的毛利占比_明细表';
-- 添加注释到列
COMMENT ON COLUMN ads_fin_yjmxb_final_guangxi_gngj.etl_time IS '调度时间';
COMMENT ON COLUMN ads_fin_yjmxb_final_guangxi_gngj.g_opecenter IS '营运中心';
COMMENT ON COLUMN ads_fin_yjmxb_final_guangxi_gngj.g_period IS '会计期间';
COMMENT ON COLUMN ads_fin_yjmxb_final_guangxi_gngj.g_inter_or_dom IS '国际国内';
COMMENT ON COLUMN ads_fin_yjmxb_final_guangxi_gngj.g_inter_or_dom_fenkaitongji
IS '每个月国际国内数量';
COMMENT ON COLUMN ads_fin_yjmxb_final_guangxi_gngj.g_inter_or_dom_tatal IS '每个月国际国内总数量';
COMMENT ON COLUMN ads_fin_yjmxb_final_guangxi_gngj.g_zb_gngj IS '国际国内的毛利占比';
4、
5、
6、
7、
8、