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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Rob Richardson <RDRichardson(at)rad-con(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: How can I use crosstab functons in PostgreSQL 9.3?
Date: 2015-10-15 15:15:23
Message-ID: CAKFQuwZUCCAkUjiDx5uKnXN7mHd7KtCd0XZDaPVN_VzRuzBMwQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Oct 15, 2015 at 10:48 AM, Rob Richardson <RDRichardson(at)rad-con(dot)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.​

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2015-10-15 15:17:43 Re: question
Previous Message Geoff Winkless 2015-10-15 15:04:26 Re: postgres function