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