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 <schema_name> If specified, only show types from the specified schema. 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 ↑