Postgres操作之视图

金鱼kk

于 2022-10-11 22:12:42 发布

阅读量90

点赞数

分类专栏： Postgres 文章标签：数据库

本文链接：https://blog.youkuaiyun.com/weixin_44548228/article/details/127272848

版权

Postgres 专栏收录该内容

16 篇文章

订阅专栏

DROP VIEW IF EXISTS t_video_catalog;

CREATE OR REPLACE VIEW "public"."t_video_catalog" AS

 SELECT t1.xh AS fd_id,

    t1.fzmc AS fd_catalogname,

    t1.yhz AS fd_catalogid,

    t1.ylzd1 AS fd_parentcatalogid,

    calculatecataloglevel(t1.yhz) AS fd_cataloglevel,

    calculatecatalogdevicestatus(t1.yhz, 'ALL'::character varying) AS fd_all,

    calculatecatalogdevicestatus(t1.yhz, 'ONLINE'::character varying) AS fd_online,

    calculatecatalogdevicestatus(t1.yhz, 'OFFLINE'::character varying) AS fd_offline,

    calculatecatalogdevicestatus(t1.yhz, 'OTHER'::character varying) AS fd_other

   FROM b_spjk_spfzb t1;

 

ALTER TABLE "public"."t_video_catalog" OWNER TO "postgres";