PostgreSQL运维常用命令 | Chan Revival Sky

[chanrevival]

https://chanrevival.github.io/2024/11/26/PostgreSQL%E8%BF%90%E7%BB%B4%E5%B8%B8%E7%94%A8%E5%91%BD%E4%BB%A4/

PostgreSQL运维常用命令查看当前连接的用户名12select * from current_userselect user 给普通用户授权1GRANT USAGE ON SCHEMA sch_user TO usr_user; 查询表大小，不含索引