Materialize Documentation
Join the Community github/materialize

SHOW TYPES

SHOW TYPES returns a list of the data types in your Materialize instance. By default, only custom types are returned.

Syntax

SHOW TYPES FROM schema_name
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