In the last two recipes, we showed you how to install external modules in PostgreSQL to augment its capabilities.
In this recipe, we will show you some more capabilities that are offered by the extension infrastructure.
The following are the steps to manage the extensions:
- First, we list all the available extensions:
postgres=# \x on Expanded display is on. postgres=# SELECT * postgres-# FROM pg_available_extensions postgres-# ORDER BY name; -[ RECORD 1 ]-----+-------------------------------------------------- name | adminpack default_version | 2.0 installed_version | comment | administrative functions for PostgreSQL -[ RECORD 2 ]-----+-------------------------------------------------- name | pg_stat statements default_version | 1.6 installed_version | comment | track execution statistics of all SQL statements executed (...)
In particular, if the dblink
extension is installed, then we see a record such...