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)
Comments
0 comments
Article is closed for comments.