切换到 postgres 用户:sudo su - postgres
打开 PostgreSQL 控制台:psql
;退出控制台:quit
管理指令:
- 查看所有数据库:
\l
- 进入数据库:
\c 数据库名字
- 查看数据库中所有表格名称:
SELECT tablename FROM pg_tables WHERE tablename NOT LIKE 'pg%' AND tablename NOT LIKE 'sql_%' ORDER BY tablename;
- 退出数据库:
Ctrl+Z
其他指令:
- 查看所有数据库大小:
select pg_database.datname, pg_size_pretty (pg_database_size(pg_database.datname)) AS size from pg_database;
- 查看所有表大小:
select relname, pg_size_pretty(pg_relation_size(relid)) from pg_stat_user_tables where schemaname='public' order by pg_relation_size(relid) desc;