Postgres Pro
Downloads
Home   >   mailing lists

Re: Crossing/Rotating table rows to rows and columns - Mailing list pgsql-sql

From Christophe Pettus
Subject Re: Crossing/Rotating table rows to rows and columns
Date
Msg-id 82BA6332-81EC-40E4-92AF-5A5254DB32BF@thebuild.com
Whole thread Raw
In response to Crossing/Rotating table rows to rows and columns  (Iuri Sampaio <iuri.sampaio@gmail.com>)
Responses Re: Crossing/Rotating table rows to rows and columns
List pgsql-sql
Tree view 

> On Sep 2, 2020, at 19:58, Iuri Sampaio <iuri.sampaio@gmail.com> wrote:
> I've tried to use crosstabN(text sql), to solve the problem directly in the datasource layer, but apparently
tablefuncis 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@thebuild.com

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: value returned by EXTRACT, date_part
Next
From: Iuri Sampaio
Date:
Subject: Crossing/Rotating table rows to rows and columns