PostgreSQL基础 create 创建复合类型

CentOS 7.6.1810
postgresql 14.4

create 创建复合类型

postgres=# create type product as (pro_id int, pro_count int);
CREATE TYPE
postgres=# \dT
       List of data types
 Schema |  Name   | Description 
--------+---------+-------------
 public | product | 
(1 row)

postgres=# \dT+
                                        List of data types
 Schema |  Name   | Internal name | Size  | Elements |  Owner   | Access privileges | Description 
--------+---------+---------------+-------+----------+----------+-------------------+-------------
 public | product | product       | tuple |          | postgres |                   | 
(1 row)

postgres=# \d product
           Composite type "public.product"
  Column   |  Type   | Collation | Nullable | Default 
-----------+---------+-----------+----------+---------
 pro_id    | integer |           |          | 
 pro_count | integer |           |          | 

postgres=# 

学习资料

• postgresql
• download-postgresql
• docs-postgresql
• db-engines
• 墨天轮社区

欢迎各位同学一起来交流学习心得！