pg_catalog | pg_amop | 数据表 | postgres | 80 kB |
pg_catalog | pg_amproc | 数据表 | postgres | 64 kB |
pg_catalog | pg_attrdef | 数据表 | postgres | 8192 bytes |
pg_catalog | pg_attribute | 数据表 | postgres | 416 kB |
pg_catalog | pg_auth_members | 数据表 | postgres | 40 kB |
pg_catalog | pg_authid | 数据表 | postgres | 40 kB |
pg_catalog | pg_available_extension_versions | 视图 | postgres | 0 bytes |
pg_catalog | pg_available_extensions | 视图 | postgres | 0 bytes |
。。。。。。省略。。。。。。
\d[S+] 名称 : 描述表,视图,序列,或索引
postgres=# \dS pg_attribute
数据表 "pg_catalog。pg_attribute"
栏位 | 类型 | Collation | Nullable | Default
---------------+-----------+-----------+----------+---------
attrelid | oid | | not null |
attname | name | | not null |
atttypid | oid | | not null |
attstattarget | integer | | not null |
attlen | smallint | | not null |
attnum | smallint | | not null |
attndims | integer | | not null |
attcacheoff | integer | | not null |
atttypmod | integer | | not null |
attbyval | boolean | | not null |
attstorage | "char" | | not null |
attalign | "char" | | not null |
attnotnull | boolean | | not null |
atthasdef | boolean | | not null |
attidentity | "char" | | not null |
attisdropped | boolean | | not null |
attislocal | boolean | | not null |
attinhcount | integer | | not null |
attcollation | oid | | not null | postgresql命令大全postgresql常用命令(4):http://www.youerw.com/fanwen/lunwen_99316.html