postgresql常用命令

解决postgresql数据库数据表锁死问题

1、查询锁死表的pid select pid from pg_locks where relation in (select oid from pg_class where relname='表名'); 2、解锁数据表 select pg_terminate_backend('上一步查询到的pid');

postgresql中没有dual表解决方案

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;