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 CREATE EXTENSION
On this page
The SHOW CREATE EXTENSION command returns the CREATE EXTENSION statement used to create an Extension.
Syntax
SHOW CREATE EXTENSION
Remark
-
Refer to the Permissions Matrix for the required permission.
Example
The output is formatted for readability.
SHOW CREATE EXTENSION ts9 \G
*** 1. row ***
Extension: ts9
Create Extension: CREATE EXTENSION `ts9` FROM
Extension Script: -- Create both functions that make up the extension
CREATE FUNCTION ts9_to_str AS WASM FROM LOCAL INFILE "ts9.wasm" WITH WIT FROM LOCAL INFILE "ts9.wit";
CREATE FUNCTION str_to_ts9 AS WASM FROM LOCAL INFILE "ts9.wasm" WITH WIT FROM LOCAL INFILE "ts9.wit";Last modified: