SHOW TYPES
NOTE!
For improved performance, execute this command in the
mz_introspection cluster. To switch clusters, use SET CLUSTER = mz_introspection;.
SHOW TYPES returns a list of the data types in your Materialize instance. By default, only custom types are returned.
Syntax
| Field | Use |
|---|---|
| schema_name | The schema to show types from. Defaults to public in the current database. For available schemas, see SHOW SCHEMAS. |
Examples
Show custom data types
SHOW TYPES;
name
-----------
int4_list