SHOW EXTENSIONS

The SHOW EXTENSIONS command lists the Extensions installed in the current or specified database.

Syntax

SHOW EXTENSIONS
[{FROM | IN} database]
[LIKE 'pattern']

Argument

  • FROM database or IN database: Lists the extensions in the specified database.

  • LIKE 'pattern': Returns a list of Extensions that match the specified pattern.

Remarks

  • Run the SHOW EXTENSIONS command without the FROM or IN clause to list all the Extensions in the current database.

  • Refer to the Permissions Matrix for the required permission.

Examples

  • List all the Extensions in the current database:

    SHOW EXTENSIONS;
    +----------------------+
    | Extensions_in_dbTest |
    +----------------------+
    | ts9                  |
    | str_to_ts9           |
    +----------------------+
  • List the Extensions in the specified database with names matching a specific pattern:

    SHOW EXTENSIONS FROM dbTest LIKE 't%';
    +---------------------------+
    | Extensions_in_dbTest (t%) |
    +---------------------------+
    | ts9                       |
    +---------------------------+

Last modified:

Was this article helpful?