本篇内容介绍了“Postgresql有哪些常用命令”的有关知识，在实际案例的操作过程中，不少人都会遇到这样的困境，接下来就让小编带领大家学习一下如何处理这些情况吧！希望大家仔细阅读，能够学有所成！

--设置模式setsearch_pathtofirsoul;--默认只列出当前模式下的表\d--列出常用模式\dn--列出所有模式\dnS--查看表的大小selectpg_size_pretty(pg_relation_size('test'));--or\dt+test--infoSELECTn.nspnameas"Schema",c.relnameas"Name",CASEc.relkindWHEN'r'THEN'table'WHEN'v'THEN'view'WHEN'm'THEN'materializedview'WHEN'i'THEN'index'WHEN'S'THEN'sequence'WHEN's'THEN'special'WHEN'f'THEN'foreigntable'WHEN'p'THEN'table'ENDas"Type",pg_catalog.pg_get_userbyid(c.relowner)as"Owner",pg_catalog.pg_size_pretty(pg_catalog.pg_table_size(c.oid))as"Size",pg_catalog.obj_description(c.oid,'pg_class')as"Description"FROMpg_catalog.pg_classcLEFTJOINpg_catalog.pg_namespacenONn.oid=c.relnamespaceWHEREc.relkindIN('r','p','s','')ANDn.nspname!~'^pg_toast'ANDc.relnameOPERATOR(pg_catalog.~)'^(test)$'ANDpg_catalog.pg_table_is_visible(c.oid)ORDERBY1,2;--查看模式大小,表，索引selectschemaname,round(sum(pg_total_relation_size(schemaname||'.'||tablename))/1024/1024)"Size_MB"frompg_tableswhereschemaname='public'groupby1;selectschemaname,round(sum(pg_total_relation_size(schemaname||'.'||tablename))/1024/1024)"Size_MB"frompg_tableswhereschemaname='public'groupby1;selectschemaname,round(sum(pg_total_relation_size(schemaname||'.'||indexname))/1024/1024)"Size_MB"frompg_indexeswhereschemaname='public'groupby1;--查询数据库大小selectdatname,pg_size_pretty(pg_database_size(datname))frompg_database;

“Postgresql有哪些常用命令”的内容就介绍到这里了，感谢大家的阅读。如果想了解更多行业相关的知识可以关注亿速云网站，小编将为大家输出更多高质量的实用文章！