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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How can I use crosstab functons in PostgreSQL 9.3?
Дата
Msg-id CAKFQuwZUCCAkUjiDx5uKnXN7mHd7KtCd0XZDaPVN_VzRuzBMwQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How can I use crosstab functons in PostgreSQL 9.3?  (Rob Richardson <RDRichardson@rad-con.com>)
Список pgsql-general
On Thu, Oct 15, 2015 at 10:48 AM, Rob Richardson <RDRichardson@rad-con.com> 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.​

В списке pgsql-general по дате отправления:

Предыдущее
От: Geoff Winkless
Дата:
Сообщение: Re: postgres function
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: Installing plpython3u