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: