SHOW CREATE TYPE
SHOW CREATE TYPE returns the DDL statement used to create the custom type.
Syntax
SHOW [REDACTED] CREATE TYPE <type_name>
| Option | Description |
|---|---|
| REDACTED | If specified, literals will be redacted. |
For available type names names, see SHOW TYPES.
Examples
SHOW CREATE TYPE point;
name | create_sql
------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
point | CREATE TYPE materialize.public.point AS (x pg_catalog.int4, y pg_catalog.int4);
Privileges
USAGEprivileges on the schema containing the table.