查看所有数据库占用磁盘空间
SELECTpg_database.datname AS "数据库名称",pg_size_pretty(pg_database_size(pg_database.datname)) AS "磁盘占用空间"
FROMpg_database;发现有个数据库占用空间过大
查询库中所有表占用空间
SELECTtable_name,pg_size_…
UserInfo表 **建表** CREATE TABLE USERINFO ( customerID INT AUTO_INCREMENT COMMENT 客户编号, customerName CHAR(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 开户名, PID CHAR(18) CHARACTER SET utf8mb4 COLLATE utf8mb4_gener…