From: | Martin Mueller <martinmueller(at)northwestern(dot)edu> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | crosstab function |
Date: | 2019-02-27 01:51:13 |
Message-ID: | 3B0E0069-18FC-476D-90A1-5201891AA52C@northwestern.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2019-02-27 02:04:17 | Re: crosstab function |
Previous Message | Adrian Klaver | 2019-02-26 23:56:22 | Re: replication topography |