crosstab function - Mailing list pgsql-general

From Martin Mueller
Subject crosstab function
Date
Msg-id 3B0E0069-18FC-476D-90A1-5201891AA52C@northwestern.edu
Whole thread Raw
Responses Re: crosstab function
Re: crosstab function
Re: crosstab function
Re: crosstab function
List pgsql-general

I run Postgres 10.5.  I understand that there is something called tablefunc and it includes a crosstab function. On Stack Overflow I learn that you import this function. But from where and how?  The Postgres documentation is quite clear and intelligible to a retired English professor like me, but there is nothing in the Postgres documentation about how to do the import, and a search for ‘import modules’ yields nothing.

 

I tried to emulate a Stack overflow query that does what I want to do, but got an error message saying that the crosstab function doesn’t exist. I tried

 

CREATE EXTENSION IF NOT EXISTS tablefunc;

 

but it did nothing. It doesn’t seem to work  as import statements in Python do

-----

Martin Mueller
Professor emeritus of English and Classics

Northwestern University

 

 

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: replication topography
Next
From: Adrian Klaver
Date:
Subject: Re: crosstab function