Re: How can I use crosstab functons in PostgreSQL 9.3?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Thu, Oct 15, 2015 at 10:48 AM, Rob Richardson <RDRichardson@xxxxxxxxxxx> wrote:

By George, I think I've got it!

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.

David J.​