SHOW TYPES

SHOW TYPES returns a list of the data types in Materialize. 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 first resolvable schema in the search path. For available schemas, see SHOW SCHEMAS.

Examples

Show custom data types

SHOW TYPES;
   name
-----------
 int4_list
Back to top ↑