May 2018
Intermediate to advanced
576 pages
30h 25m
English
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 ...