Question

问题

Questions in category: PostgreSQL (PostgreSQL).

PostgreSQL 中视图的创建删除

Posted by haifeng on 2014-12-21 12:02:52 last update 2014-12-21 12:02:52 | Answers (0) | 收藏

PostgreSQL 9.3 内建了物化视图

如果安装的 PostgreSQL 9.1, 则一般只能建立虚拟视图

CREATE [TEMP | TEMPORARY] VIEW view_name AS SELECT column1, column2..... FROM table_name WHERE [condition];

References:

http://www.yiibai.com/postgresql/2013080777.html