SHOW CREATE EXTENSION

The SHOW CREATE EXTENSION command returns the CREATE EXTENSION statement used to create an Extension.

Syntax

SHOW CREATE EXTENSION

Remark

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:

Was this article helpful?