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