云数据库 GaussDB-CREATE VIEW:示例

时间:2025-02-12 15:08:28

示例

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