PostPreSql 数据库的一些用法

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、