PostgreSQL comes with several data types, but users can create custom types to most faithfully represent any value. Data type management is mostly, but not exclusively, a developer's job, and data type design goes beyond the scope of this book. This is a quick recipe that covers only the simpler problem of the need to apply a specific change to an existing data type.
Changing the definition of a data type
Getting ready
Enumerative data types are defined like this:
CREATE TYPE satellites_urani AS ENUM ('titania','oberon');
The other popular case is composite data types, which are created as follows:
CREATE TYPE node AS
( node_name text,
connstr text,
standbys text[]);