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