When I ran CREATE EXTENSION tablefunc WITH SCHEMA public, I got the crosstab methods and my sample query worked.
I would suggest learning about search_path(s) instead of placing everything into the one schema that happens to be in the default search_path. Otherwise your "public" is going to be a mess to scan through.
