07-19-2021, 05:30 PM
Summary: in this tutorial, you will learn how to create PostgreSQL user-defined data type using CREATE DOMAIN and CREATE TYPE statements.
Besides built-in data types, PostgreSQL allows you to create user-defined data types through the following statements:
CREATE DOMAIN creates a user-defined data type with constraints such as NOT NULL, CHECK, etc.
CREATE TYPE creates a composite type used in stored procedures as the data types of returned values.
Read More : https://reconshell.com/postgresql-user-d...ata-types/
Besides built-in data types, PostgreSQL allows you to create user-defined data types through the following statements:
CREATE DOMAIN creates a user-defined data type with constraints such as NOT NULL, CHECK, etc.
CREATE TYPE creates a composite type used in stored procedures as the data types of returned values.
Read More : https://reconshell.com/postgresql-user-d...ata-types/