Re: How to install pgstattuple extension in postgres 10.6?

On Tue, Jul 9, 2019 at 1:53 PM Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>
wrote:

> Can someone let me know how to install pgstattuple extension in postgres
> 10.6 running on Ubuntu 16?
>
> I have installed postgres-contrib and can see the following .sql files
> under extension folder
>
> ubuntu(at)vrni-proxy:~$ ls /usr/share/postgresql/10/extension/pgstattuple*/usr/share/postgresql/10/extension/pgstattuple--1.0--1.1.sql /usr/share/postgresql/10/extension/pgstattuple--1.3--1.4.sql /usr/share/postgresql/10/extension/pgstattuple.control/usr/share/postgresql/10/extension/pgstattuple--1.1--1.2.sql /usr/share/postgresql/10/extension/pgstattuple--1.4--1.5.sql /usr/share/postgresql/10/extension/pgstattuple--unpackaged--1.0.sql/usr/share/postgresql/10/extension/pgstattuple--1.2--1.3.sql /usr/share/postgresql/10/extension/pgs
>
>

If the contrib package has been installed, all you have to do is log as a
superuser to the database you want the extension to exist and type:

CREATE EXTENSION pgstattuple;

You don't have to touch the sql files.

Keith