How to install the 'tablefunc' extension in a Postgresql database

Introduction

This article will walk you through installing the 'tablefunc' extension in a Postgresql database.

Procedure

First we need to install the 'postgresql-contrib' package:

yum install postgresql-contrib

Next, we need to log into Postgresql via command line:

psql -U postgres

Now we need to connect to the database we wish to install the 'tablefunc' extension on:

\c $your_database_name_here;

In my example, my database name will be 'cptech_pgtest':

\c cptech_pgtest;

Now we can install the extension:

CREATE EXTENSION tablefunc;

Finally, we can confirm it has now been installed:

cptech_pgtest=# \dx
List of installed extensions
Name | Version | Schema | Description
-----------+---------+------------+------------------------------------------------------------
plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
tablefunc | 1.0 | public | functions that manipulate whole tables, including crosstab
(2 rows)