Completing and verifying the extension installation

Installing the AI Database extension

The AI Database extension is an extension that provides a set of functions to run AI/ML models in the database. The extension is installed using the CREATE EXTENSION command.

ebd=# CREATE EXTENSION aidb CASCADE;
NOTICE:  installing required extension "vector"
CREATE EXTENSION
edb=#

Installing the File System extension

The File System extension is an extension that provides a set of functions to interact with the file system from within the database. The extension is installed using the CREATE EXTENSION command.

edb=# create extension pgfs;
CREATE EXTENSION

Validating the installation

You can check the extensions have been installed by running the \dx command in psql.

edb=# \dx

                                     List of installed extensions
       Name       | Version |   Schema   |                        Description
------------------+---------+------------+------------------------------------------------------------
 aidb             | 1.0.7   | aidb       | aidb: makes it easy to build AI applications with postgres
 pgfs             | 1.0.4   | pgfs       | pgfs: enables access to filesystem-like storage locations
 vector           | 0.8.0   | public     | vector data type and ivfflat and hnsw access methods

Typically, there will be other extensions listed in this view. The aidb, pgfs, and vector extensions should be listed.