云数据库 GaussDB-CREATE VIEW:示例

时间:2023-11-01 16:22:10

示例

--创建字段spcname为pg_default组成的视图。openGauss=# CREATE VIEW myView AS    SELECT * FROM pg_tablespace WHERE spcname = 'pg_default';--查看视图。openGauss=# SELECT * FROM myView ;--删除视图myView。openGauss=# DROP VIEW myView;
support.huaweicloud.com/centralized-devg-v2-opengauss/devg_03_0584.html