SHOW CREATE TYPE

View as Markdown

SHOW CREATE TYPE returns the DDL statement used to create the custom type.

Syntax

SHOW [REDACTED] CREATE TYPE <type_name>;

Syntax element	Description
REDACTED	If specified, literals will be redacted.

For available type names, see SHOW TYPES.

Examples

SHOW CREATE TYPE point;

    name                    |    create_sql
----------------------------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 materialize.public.point   | CREATE TYPE materialize.public.point AS (x pg_catalog.int4, y pg_catalog.int4);

Privileges

USAGE privileges on the schema containing the type.

Back to top ↑