CREATE EXTENSION
in the Postgres database of your choicepsql
or a Postgres client of your
choice.
Then, most extensions can be loaded using:
SELECT * FROM pg_available_extensions;
LOAD
or require other configuration. Check the documentation on
pgxman.com for more information.