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 行记录)