attacl | aclitem[] | | |
attoptions | text[] | | |
attfdwoptions | text[] | | |
索引:
"pg_attribute_relid_attnam_index" UNIQUE, btree (attrelid, attname)
"pg_attribute_relid_attnum_index" UNIQUE, btree (attrelid, attnum)
postgres=#
postgres=#
postgres=#
postgres=# \dS pg_available_extensions
视图 "pg_catalog。pg_available_extensions"
栏位 | 类型 | Collation | Nullable | Default
-------------------+------+-----------+----------+---------
name | name | | |
default_version | text | | |
installed_version | text | | |
comment | text | | |
postgres=#
添加 加号(+) 会显示更多:
postgres=# \dS+ pg_attribute
数据表 "pg_catalog。pg_attribute"
栏位 | 类型 | Collation | Nullable | Default | 存储 | 统计目标 | 描述
---------------+-----------+-----------+----------+---------+----------+----------+------
attrelid | oid | | not null | | plain | |
attname | name | | not null | | plain | |
atttypid | oid | | not null | | plain | |
attstattarget | integer | | not null | | plain | |
attlen | smallint | | not null | | plain | |
attnum | smallint | | not null | | plain | |
attndims | integer | | not null | | plain | |
attcacheoff | integer | | not null | | plain | |
atttypmod | integer | | not null | | plain | | postgresql命令大全postgresql常用命令(5):http://www.youerw.com/fanwen/lunwen_99316.html