postgresql中没有dual表解决方案

来源:互联网 发布:sqlite数据库编辑器 编辑:程序博客网 时间:2024/05/29 16:10

CREATE OR REPLACE VIEW dual AS
SELECT NULL::"unknown"
WHERE 1 = 1;

ALTER TABLE dual OWNER TO jxdx;
GRANT ALL ON TABLE dual TO jxdx;
GRANT SELECT ON TABLE dual TO public;