Steps to install 'tablefunc' extension in Postgresql

[kumkumsharma]

You can install ‘tablefunc' extension and for that you have to follow below steps:

To install 'tablefunc' extension you have to install 'postgresql-contrib' package:

yum install postgresql-contrib

First you have to login into PostgreSQL with commands.

psql -U postgres

After login connect to the database and install 'tablefunc' extension:

\c $your_database_name_here;

For example, if database name is ‘host_pgtest’

\c host_pgtest;

And now we can install tablefunc extension:

CREATE EXTENSION tablefunc;

Now this extension is installed on server.

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)