SHOW TYPES

SHOW TYPES returns a list of the data types in Materialize. Only custom types are returned.

Syntax

SHOW TYPES [FROM <schema_name>]
Option Description
FROM 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 ↑