PostgreSQL 查找当前数据库的所有表、字段

努力推石头的西西弗斯

已于 2022-03-18 15:50:44 修改

阅读量9.7k

点赞数 5

于 2020-06-11 10:50:34 首次发布

本文链接：https://blog.csdn.net/qq1620657419/article/details/106683434

版权

数据库专栏收录该内容

7 篇文章 0 订阅

订阅专栏

查看当前所有表

SELECT
	tablename 
FROM
	pg_tables 
WHERE
	tablename NOT LIKE'pg%' 
	AND tablename NOT LIKE'sql_%' 
ORDER BY
	tablename;

查看当前表的所有字段

SELECT 
	C.relname,
	A.attname AS NAME,
	A.attnotnull AS NOTNULL,
	format_type ( A.atttypid, A.atttypmod ) AS TYPE,
	col_description ( A.attrelid, A.attnum ) AS COMMENT 
FROM
	pg_class AS C,
	pg_attribute AS A 
WHERE
	C.relname = '表名' 
	AND A.attrelid = C.oid 
	AND A.attnum > 0

查看当前所有表的所有字段

SELECT C
	.relname,
	A.attname AS NAME,
	A.attnotnull AS NOTNULL,
	format_type ( A.atttypid, A.atttypmod ) AS TYPE,
	col_description ( A.attrelid, A.attnum ) AS COMMENT 
FROM
	pg_class AS C,
	pg_attribute AS A 
WHERE
	C.relname IN ( SELECT tablename FROM pg_tables WHERE tablename NOT LIKE'pg%' AND tablename NOT LIKE'sql_%' ORDER BY tablename ) 
AND A.attrelid = C.oid 
AND A.attnum > 0