创建视图
执行如下命令创建新视图MyView。
gbase=# CREATE OR REPLACE VIEW MyView AS SELECT * FROM tpcds.web_returns WHERE
trunc(wr_refunded_cash) > 10000;
CREATE VIEW
查询视图
执行如下命令查询MyView视图。
gbase=# SELECT * FROM MyView;
查看某视图的具体信息
执行如下命令查询MyView视图的详细信息。
gbase=# \d+ MyView
View "PG_CATALOG.MyView"
Column | Type | Modifiers | Storage | Description
----------+-----------------------+-----------+----------+------------- USERNAME | CHARACTER VARYING(64) | | extended | View definition:
SELECT PG_AUTHID.ROLNAME::CHARACTER VARYING(64) AS USERNAME FROM PG_AUTHID;
删除视图
执行如下命令删除MyView视图。
gbase=# DROP VIEW MyView;
DROP VIEW