Re: Crossing/Rotating table rows to rows and columns

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Iuri Sampaio <iuri(dot)sampaio(at)gmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)lists(dot)postgresql(dot)org>
Subject: Re: Crossing/Rotating table rows to rows and columns
Date: 2020-09-03 02:58:05
Message-ID: 82BA6332-81EC-40E4-92AF-5A5254DB32BF@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> On Sep 2, 2020, at 19:58, Iuri Sampaio <iuri(dot)sampaio(at)gmail(dot)com> wrote:
> I've tried to use crosstabN(text sql), to solve the problem directly in the datasource layer, but apparently tablefunc is not supported in the datamodel Squema

"tablefunc" is an extension, so you will need to create it in your database before using it:

CREATE EXTENSION tablefunc;

--
-- Christophe Pettus
xof(at)thebuild(dot)com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Iuri Sampaio 2020-09-03 02:58:46 Crossing/Rotating table rows to rows and columns
Previous Message Tom Lane 2020-08-29 16:04:32 Re: value returned by EXTRACT, date_part