Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

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?