crosstab(unknown, unknown) does not exist

在pgadminIII用到交叉表时，给报了函数不存在

 

解决方法：

执行sql

CREATE EXTENSION tablefunc;

结果

Query returned successfully with no result in 96 msec.