postgres=# \dS
关联列表
架构模式 | 名称 | 型别 | 拥有者
------------+---------------------------------+--------+----------
pg_catalog | pg_aggregate | 资料表 | postgres
pg_catalog | pg_am | 资料表 | postgres
pg_catalog | pg_amop | 资料表 | postgres
pg_catalog | pg_amproc | 资料表 | postgres
pg_catalog | pg_attrdef | 资料表 | postgres
pg_catalog | pg_attribute | 资料表 | postgres
pg_catalog | pg_auth_members | 资料表 | postgres
pg_catalog | pg_authid | 资料表 | postgres
pg_catalog | pg_available_extension_versions | 视观表 | postgres
pg_catalog | pg_available_extensions | 视观表 | postgres
pg_catalog | pg_cast | 资料表 | postgres
pg_catalog | pg_class | 资料表 | postgres
pg_catalog | pg_collation | 资料表 | postgres
pg_catalog | pg_constraint | 资料表 | postgres
pg_catalog | pg_conversion | 资料表 | postgres
pg_catalog | pg_cursors | 视观表 | postgres
pg_catalog | pg_database | 资料表 | postgres
pg_catalog | pg_db_role_setting | 资料表 | postgres
pg_catalog | pg_default_acl | 资料表 | postgres
pg_catalog | pg_depend | 资料表 | postgres
pg_catalog | pg_description | 资料表 | postgres
pg_catalog | pg_enum | 资料表 | postgres
pg_catalog | pg_extension | 资料表 | postgres
pg_catalog | pg_foreign_data_wrapper | 资料表 | postgres
pg_catalog | pg_foreign_server | 资料表 | postgres
pg_catalog | pg_foreign_table | 资料表 | postgres
pg_catalog | pg_group | 视观表 | postgres
pg_catalog | pg_index | 资料表 | postgres
pg_catalog | pg_indexes | 视观表 | postgres
pg_catalog | pg_inherits | 资料表 | postgres
pg_catalog | pg_language | 资料表 | postgres
pg_catalog | pg_largeobject | 资料表 | postgres
pg_catalog | pg_largeobject_metadata | 资料表 | postgres
pg_catalog | pg_locks | 视观表 | postgres
pg_catalog | pg_namespace | 资料表 | postgres
pg_catalog | pg_opclass | 资料表 | postgres
pg_catalog | pg_operator | 资料表 | postgres
pg_catalog | pg_opfamily | 资料表 | postgres
pg_catalog | pg_pltemplate | 资料表 | postgres
pg_catalog | pg_prepared_statements | 视观表 | postgres
pg_catalog | pg_prepared_xacts | 视观表 | postgres
pg_catalog | pg_proc | 资料表 | postgres
pg_catalog | pg_rewrite | 资料表 | postgres
pg_catalog | pg_roles | 视观表 | postgres
pg_catalog | pg_rules | 视观表 | postgres
pg_catalog | pg_seclabel | 资料表 | postgres
pg_catalog | pg_seclabels | 视观表 | postgres
pg_catalog | pg_settings | 视观表 | postgres
pg_catalog | pg_shadow | 视观表 | postgres
pg_catalog | pg_shdepend | 资料表 | postgres
pg_catalog | pg_shdescription | 资料表 | postgres
pg_catalog | pg_stat_activity | 视观表 | postgres
pg_catalog | pg_stat_all_indexes | 视观表 | postgres
pg_catalog | pg_stat_all_tables | 视观表 | postgres
pg_catalog | pg_stat_bgwriter | 视观表 | postgres
pg_catalog | pg_stat_database | 视观表 | postgres
pg_catalog | pg_stat_database_conflicts | 视观表 | postgres
pg_catalog | pg_stat_replication | 视观表 | postgres
pg_catalog | pg_stat_sys_indexes | 视观表 | postgres
pg_catalog | pg_stat_sys_tables | 视观表 | postgres
pg_catalog | pg_stat_user_functions | 视观表 | postgres
pg_catalog | pg_stat_user_indexes | 视观表 | postgres
pg_catalog | pg_stat_user_tables | 视观表 | postgres
pg_catalog | pg_stat_xact_all_tables | 视观表 | postgres
pg_catalog | pg_stat_xact_sys_tables | 视观表 | postgres
pg_catalog | pg_stat_xact_user_functions | 视观表 | postgres
pg_catalog | pg_stat_xact_user_tables | 视观表 | postgres
pg_catalog | pg_statio_all_indexes | 视观表 | postgres
pg_catalog | pg_statio_all_sequences | 视观表 | postgres
pg_catalog | pg_statio_all_tables | 视观表 | postgres
pg_catalog | pg_statio_sys_indexes | 视观表 | postgres
pg_catalog | pg_statio_sys_sequences | 视观表 | postgres
pg_catalog | pg_statio_sys_tables | 视观表 | postgres
pg_catalog | pg_statio_user_indexes | 视观表 | postgres
pg_catalog | pg_statio_user_sequences | 视观表 | postgres
pg_catalog | pg_statio_user_tables | 视观表 | postgres
pg_catalog | pg_statistic | 资料表 | postgres
pg_catalog | pg_stats | 视观表 | postgres
pg_catalog | pg_tables | 视观表 | postgres
pg_catalog | pg_tablespace | 资料表 | postgres
pg_catalog | pg_timezone_abbrevs | 视观表 | postgres
pg_catalog | pg_timezone_names | 视观表 | postgres
pg_catalog | pg_trigger | 资料表 | postgres
pg_catalog | pg_ts_config | 资料表 | postgres
pg_catalog | pg_ts_config_map | 资料表 | postgres
pg_catalog | pg_ts_dict | 资料表 | postgres
pg_catalog | pg_ts_parser | 资料表 | postgres
pg_catalog | pg_ts_template | 资料表 | postgres
pg_catalog | pg_type | 资料表 | postgres
pg_catalog | pg_user | 视观表 | postgres
pg_catalog | pg_user_mapping | 资料表 | postgres
pg_catalog | pg_user_mappings | 视观表 | postgres
pg_catalog | pg_views | 视观表 | postgres
(93 行记录)
pg_user和pg_roles表结构对比
postgres=# \d pg_user;
视观表 "pg_catalog.pg_user"
栏位 | 型别 | 修饰词
-------------+---------+--------
usename | name |
usesysid | oid |
usecreatedb | boolean |
usesuper | boolean |
usecatupd | boolean |
userepl | boolean |
passwd | text |
valuntil | abstime |
useconfig | text[] |
postgres=# \d pg_roles;
视观表 "pg_catalog.pg_roles"
栏位 | 型别 | 修饰词
----------------+--------------------------+--------
rolname | name |
rolsuper | boolean |
rolinherit | boolean |
rolcreaterole | boolean |
rolcreatedb | boolean |
rolcatupdate | boolean |
rolcanlogin | boolean |
rolreplication | boolean |
rolconnlimit | integer |
rolpassword | text |
rolvaliduntil | timestamp with time zone |
rolconfig | text[] |
oid | oid |