Skip to content

Postgres composite type, "CREATE TYPE" #426

@jwc65535

Description

@jwc65535

Does dbtpl support Postgres composite type, "CREATE TYPE"?

CREATE TYPE address_type AS (
    street_line1 VARCHAR(100),
    street_line2 VARCHAR(100),
    city VARCHAR(50),
    zip_code VARCHAR(10)
);

CREATE TABLE customer (
    customer_id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
    name VARCHAR(50) NOT NULL UNIQUE,
    created_at TIMESTAMP WITH TIME ZONE DEFAULT CURRENT_TIMESTAMP,
    billto_address address_type,
    shipto_address address_type
);

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions