Re: BUG #14024: problem in Creating pivot table - Mailing list pgsql-bugs

amr.fadly@vodafone.com writes:
> we are trying to do the example in the documentation to create pivot table
> using crosstab function, it is not working and gives the below error:

> ERROR: function crosstab(unknown, unknown) does not exist

crosstab() is in the tablefunc extension, which you evidently haven't
installed (basically "CREATE EXTENSION tablefunc").  See the general
installation instructions at

http://www.postgresql.org/docs/9.5/static/contrib.html

            regards, tom lane