Another strength of PostgreSQL is its extensibility. Extensibility was one of the original design goals, going back to the late 1980s. Now, in PostgreSQL 10, there are many additional modules that plug into the core PostgreSQL server.
There are many kinds of additional module offerings, such as the following:
- Additional functions
- Additional data types
- Additional operators
- Additional index types
The procedure that makes a module usable is actually a two-step process. First, you install the module's files on your system so that they become available to the database server. Next, you connect...