如何查看PostgreSQL数据库中所有表

select * from pg_tables;

select tablename from pg_tables where schemaname='public'

postgres=# select tablename from pg_tables where schemaname='public';
tablename
-----------
tb_test
(1 行记录)

postgres=# \d tb_test;
        数据表 "public.tb_test"
栏位 |   类型   | Collation | Nullable | Default
------+----------------+-----------+----------+---------
id  | integer    |      |     |
name | character(100) |      |     |

postgres=# insert into tb_test(id,name) values(1,'huangbaokang');
INSERT 0 1
postgres=# select * from tb_test;
id |                         name

----+-----------------------------------------------------------------
---------------------------
 1 | huangbaokang

(1 行记录)

select pg_size_pretty(pg_tablespace_size('pg_default'));

select pg_database.datname, pg_size_pretty(pg_database_size(pg_database.datname)) AS size from pg_databas;

select pg_size_pretty(pg_relation_size('索引字段名'));

select pg_size_pretty(pg_indexes_size('表名'));

select relname,indexrelname, pg_size_pretty(pg_relation_size(relid)) from pg_stat_user_indexes where schemaname='模式名' order by pg_relation_size(relid) desc;

select pg_size_pretty(pg_relation_size('表名'));

select pg_size_pretty(pg_total_relation_size('表名'));

select relname, pg_size_pretty(pg_relation_size(relid)) from pg_stat_user_tables where schemaname='模式名' order by pg_relation_size(relid) desc;

SELECT
  table_size.relname 表名,
  pg_size_pretty ( pg_relation_size ( relid ) ) 表数据大小,
  pg_size_pretty ( pg_indexes_size ( relid ) ) 表总索引大小,
  pg_size_pretty ( pg_total_relation_size ( relid ) ) 表总大小,
  表行数
FROM
pg_stat_user_tables table_size
  LEFT JOIN (
    SELECT
      relname,
      reltuples :: DECIMAL ( 19, 0 ) 表行数
    FROM
    pg_class r
    JOIN pg_namespace n ON ( relnamespace = n.oid )
    WHERE
      relkind = 'r'
      AND n.nspname = '模式名'
    ) table_num ON table_num.relname = table_size.relname
WHERE
  schemaname = '模式名'
ORDER BY
  pg_relation_size ( relid ) DESC;