create view myview as select * from mytab;
上面创建视图的语句与下面两个命令的执行结果是相同的:
create table myvire (same column list as mytab);
create rule "_RETURN" as on select to myview DO INSTEAD SELECT * FROM mytab;
由此可见,视图实际上是一张表,不过是在这种表中加了一个select柜子
From:《PostgreSql修炼之道--从小工到专家》P302
上面创建视图的语句与下面两个命令的执行结果是相同的:
create table myvire (same column list as mytab);
create rule "_RETURN" as on select to myview DO INSTEAD SELECT * FROM mytab;
由此可见,视图实际上是一张表,不过是在这种表中加了一个select柜子
From:《PostgreSql修炼之道--从小工到专家》P302