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

  • USAGE privileges on the schema containing the table.
Back to top ↑