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

[Tom Lane]

Rob Richardson <rdrichard...@rad-con.com> writes:
> I am trying to learn about crosstab functions in ProgreSQL 9.3, but none of 
> the examples I’ve found are working.  I get errors claiming the functions 
> are unknown, but when I try running CREATE EXTENSION tablefunc, I am told 
> that its methods already exist.

This looks like a search_path problem.  You could try "\dx+ tablefunc"
to see which schema its functions are in, then adjust your search_path
to include that, or else schema-qualify the function names.

                        regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general