PostgreSQL allows you to create your own data types that are specific data abstractions you can use in your tables, functions, and other database objects.
While PostgreSQL comes with a very rich set of built-in data types, being able to create and customize your own types makes the database more flexible and able to handle very special cases.
This chapter will show you the basic concepts of creating, using, and managing custom data types. However, before you rush into creating your own custom data type, please consider reading the official documentation and searching for the available data types.
In the following sections, we will cover the following topics:
- Creating an enumerated data type
- Creating a composite data type
- Creating your own basic data type