1. 查询表名称

在psql状态下查询表名称

\dt

SQL方式查看表名称

SELECT tablename FROM pg_tables;

SELECT viewname FROM pg_views;

PostgreSQL获取数据库中所有view名 视图

SELECT viewname FROM pg_views WHERE schemaname = 'public' ;

2. 查询表结构

在psql状态下查询表结构

\d tablename

SQL方式查看表结构：

SELECT 
  A.attnum, 
  A.attname AS field, 
  T.typname AS TYPE, 
  A.attlen AS LENGTH, 
  A.atttypmod AS lengthvar, 
  A.attnotnull AS NOTNULL, 
  b.description AS COMMENT 
FROM 
  pg_class C, 
  pg_attribute A 
  LEFT OUTER JOIN pg_description b ON A.attrelid = b.objoid 
  AND A.attnum = b.objsubid, 
  pg_type T 
WHERE 
  C.relname = 'pg_class' 
  AND A.attnum > 0 
  AND A.attrelid = C.oid 
  AND A.atttypid = T.oid 
ORDER BY 
  A.attnum;

参考：https://blog.csdn.net/weixin_39713335/article/details/112926022