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 super user. For instance, if you want to install the dblink extension, type this:

CREATE EXTENSION dblink;