Installing and Using PostgreSQL Extensions

PostgreSQL extensions live in a given database, even when their deployment includes shared object libraries that are usually system-wide. Depending on your operating system, a shared object might be a .so, .dll, or .dylib file.

Enable the extension

Once the support files for an extension are deployed at the right place on your operating system, we can type the following SQL command to enable the trigram extension in the current database we’re connected to:

create extension pg_trgm;

Installing the support files for an ...