NAME CREATE_TYPE - define a new data type SYNOPSIS CREATE TYPE name AS ( [ attribute_name ... data_type [ COLLATE collation ] [, ... ] ] ) CREATE TYPE name AS ENUM ( [ ' label ' [,…type, using the same syntax as CREATE TYPE . DROP ATTRIBUTE [ IF EXISTS ] This form drops ... properties that can be set in CREATE TYPE . Specifically, these properties can be chan…desired behavior in such cases. See CREATE TYPE ( CREATE_TYPE (7)) for more information ... ALSO CREATE FUNCTION ( CREATE_FUNCTION (7)), CREATE TYPE ( CREATE_TYPE (7)), DROP CAST (…composite type and a typed table: CREATE TYPE employee_type AS (name text, salary numeric ... CREATE TABLESPACE ( CREATE_TABLESPACE (7)), CREATE TYPE ( CREATE_TYPEtype and the language: CREATE TYPE hstore ...; CREATE EXTENSION plpython3u; Then create the necessary functions ... CREATE LANGUAGE ( CREATE_LANGUAGE (7)), CREATE TYPE ( CREATE_TYP…note that much of the CREATE TYPE command and the data type extension mechanisms ... ALSO ALTER TYPE ( ALTER_TYPE (7)), CREATE TYPE ( CREATE_TYPEotherwise the synchronization will fail (see CREATE TYPE ( CREATE_TYPE (7)) for more about send/receivewith an explicitly named composite type: CREATE TYPE dup_result AS (f1 int, f2 textAdditionally the -EncryptedData_encrypt and -data_create type cannot be processed by the older openssl