11

I used StackBuilder to install Postgres 9.2 on my Mac OS X machine.

Now I need to use tablefunc and it seems that the function is not available.

How do I install the contrib package on the Mac?

Jack Gibson
  • 1,831
  • 5
  • 21
  • 34
  • 2
    http://www.postgresql.org/docs/current/static/sql-createextension.html –  Jul 29 '13 at 22:13
  • Thanks - In fact it was enough to execute CREATE EXTENSION tablefunc; I tought I need to install some module... – Jack Gibson Jul 29 '13 at 22:56

1 Answers1

25

As suggested by a_horse_with_no_name the solution was simple.

I just had to execute:

CREATE EXTENSION tablefunc;
Jack Gibson
  • 1,831
  • 5
  • 21
  • 34
  • using this, I ran into the next issue `ERROR: materialize mode required, but it is not allowed in this context` – Ulysse BN Nov 15 '18 at 09:20