postgreSQL 查询表结构表注释表列名、数据类型、数据长度、是否非空、注释

最新推荐文章于 2024-03-22 20:59:22 发布

郁诙邪

最新推荐文章于 2024-03-22 20:59:22 发布

阅读量1.5k

点赞数

分类专栏： SQL 文章标签： postgresql 数据库

本文链接：https://blog.csdn.net/a2117971372/article/details/128729683

版权

SQL 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

SELECT 
	t1.column_name,
	t1.is_nullable,
	t1.udt_name,
	COALESCE ( character_maximum_length, datetime_precision ) max_length,
	CAST ( obj_description ( t4.oid ) AS VARCHAR ) table_description,
	t3.description 
FROM
	information_schema.COLUMNS t1
	LEFT JOIN pg_attribute t2 ON (t1.column_name = t2.attname)
	LEFT JOIN pg_description t3 ON (t3.objoid = t2.attrelid AND t3.objsubid = t2.attnum)
	LEFT JOIN pg_class t4 ON (t2.attrelid = t4.oid)
WHERE
	table_schema = 'public' 
	AND TABLE_NAME = '表名'
	AND t2.attnum >= 0 
	AND t4.relname ='表名'