user-defined-type-fullname

ALTER TYPE cycling.fullname
ADD middlename text;

ALTER TYPE cycling.fullname
RENAME middlename TO middle
  AND lastname TO last
  AND firstname TO first;

ALTER TYPE cycling.fullname
RENAME middle to middlename
  AND last to lastname
  AND first TO firstname;

CREATE TYPE IF NOT EXISTS cycling.fullname (
  firstname text,
  lastname text
);

DESCRIBE TYPE cycling.fullname;

DESCRIBE TYPE cycling.fullname;

DESCRIBE TYPE cycling.fullname;

DESCRIBE TYPE cycling.fullname;

DROP TYPE IF EXISTS cycling.fullname;

Give Feedback