PostgreSQL 11 Administration Cookbook

How to do it…

Each extension has a unique name, so it is just a matter of issuing the following command:

CREATE EXTENSION myextname;

This will automatically create all the required objects inside the current database.

For security reasons, you need to do so as a database superuser. For instance, if you want to install the dblink extension, type this:

CREATE EXTENSION dblink;