pgsql查询表名与表结构

查询表名称

在psql状态下查询表名称

\dt

sql方式查询表名称

SELECT tablename FROM pg_tables;

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

SELECT viewname 
FROM pg_views  
WHERE schemaname ='public'

查询表结构

在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 = 'par_service_sql_desc_iss'   -- 替换为你的表名
and a.attnum > 0
and a.attrelid = c.oid
and a.atttypid = t.oid
ORDER BY a.attnum;
posted @ 2021-07-28 09:18  香草味的薄荷糖  阅读(3215)  评论(0编辑  收藏  举报