自定义数据类型相关操作
最近更新时间: 2024-06-12 15:06:00
建立数据类型。
postgres=# CREATE TYPE bug_status AS ENUM('new', 'open', 'closed'); CREATE TYPE
\dT查看自定义数据类型列表。
postgres=# \dT List ofdata types Schema | Name | Description -----------+------------+-------------------------- pg_oracle | nvarchar2 | oracle nvarchar2(length) pg_oracle | varchar2 | oracle varchar2(length) public | bug_status |
\dT+查看自定义数据类型列表详细信息(包含enum类型的值)。
postgres=# \dT+ List ofdata types Schema | Name | Internal name | Size |Elements | Access privileges | Description -----------+------------+---------------+-------+----------+-------------------+-------------------------- pg_oracle | nvarchar2 | nvarchar2 | var | | | oracle nvarchar2(length) pg_oracle | varchar2 | varchar2 | var | | | oracle varchar2(length) public | bug_status | bug_status | 4 | new +| | | | | | open +| | | | | | closed | |
\dT+显示某个模式下的所有自定义类型。
postgres=# \dT+ public.* List ofdata types Schema | Name | Internal name | Size |Elements | Access privileges | Description --------+------------+---------------+-------+----------+-------------------+------------- public | bug_status | bug_status | 4 | new +| | | | | | open +| | | | | | closed | |
\dT+自定义数据类型显示某个数据类型的详细信息。
postgres=# \dT+ bug_status List ofdata types Schema | Name | Internal name | Size |Elements | Access privileges | Description --------+------------+---------------+------+----------+-------------------+------------- public | bug_status | bug_status | 4 | new +| | | | | | open +| | | | | | closed | | (1 row)
\dT+通配符列出适配的数据类型。
postgres=# \dT+ bug_* List ofdata types Schema | Name | Internal name | Size |Elements | Owner | Access privileges | Description --------+------------+---------------+------+----------+-------+-------------------+------------- public | bug_status | bug_status | 4 | new +| tbase | | | | | | open +| | | | | | | closed | | |