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.