PostgreSQL 11 Administration Cookbook

How it works…

The pg_available_extensions system view shows one row for each extension control file in the SHAREDIR/extension directory (see the Using an installed module recipe). The pg_extension catalog table records only the extensions that have actually been created.

The psql command-line utility provides the \dx meta-command to examine the extensions. It supports an optional plus sign (+) to control verbosity, and an optional pattern for the extension name to restrict its range. Consider the following command:

\dx+ db*

This will list all extensions whose names start with db, together with all their objects.

The CREATE EXTENSION command creates all objects belonging to a given extension and then records the dependency of each object on ...