CREATE TYPE myenum AS ENUM ('red', 'green');

CREATE TABLE exact_output (
    id int,
    test_bool boolean,
    test_date date,
    test_int16 smallint,
    test_int32 int,
    test_int64 bigint,
    test_text text,
    test_timestamp_without_time_zone timestamp,
    test_timestamp_with_time_zone timestamp with time zone,
    test_uuid uuid,
    "select" text,
    testCapitalized text,
    test_enum myenum
);