fullname
User-defined type that contains two fields for first name and last name.
CREATE TYPE IF NOT EXISTS cycling.fullname (
firstname text,
lastname text
);
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;
Displaying command results
DESC TYPE cycling.fullname;
CREATE TYPE cycling.fullname (
firstname text,
lastname text,
middlename text
);
Drop user-defined type
DROP TYPE IF EXISTS cycling.fullname;