Laughing
PostgreSql查看列信息
07/14
本文最后更新于2023年07月14日，已超过289天没有更新。如果文章内容或图片资源失效，请留言反馈，我会及时处理，谢谢！
select ordinal_position as Colorder,
column_name as ColumnName,
data_type as TypeName,
coalesce(character_maximum_length, numeric_precision, -1) as Length,
numeric_scale as Scale,
case is_nullable when 'NO' then 0 else 1 end as CanNull,
column_default as DefaultVal,
case when position('nextval' in column_default) > 0 then 1 else 0 end as IsIdentity,
case when b.pk_name is null then 0 else 1 end as IsPK,
c.DeText
from information_schema.columns
left join (select pg_attr.attname as colname, pg_constraint.conname as pk_name
from pg_constraint
inner join pg_class on pg_constraint.conrelid = pg_class.oid
inner join pg_attribute pg_attr
on pg_attr.attrelid = pg_class.oid and pg_attr.attnum = pg_constraint.conkey[1]
inner join pg_type on pg_type.oid = pg_attr.atttypid
where pg_class.relname = '表名'
and pg_constraint.contype = 'p') b on b.colname = information_schema.columns.column_name
left join (select attname, description as DeText
from pg_class
left join pg_attribute pg_attr on pg_attr.attrelid = pg_class.oid
left join pg_description pg_desc
on pg_desc.objoid = pg_attr.attrelid and pg_desc.objsubid = pg_attr.attnum
where pg_attr.attnum > 0
and pg_attr.attrelid = pg_class.oid
and pg_class.relname = '表名') c on c.attname = information_schema.columns.column_name
where table_schema = '架构'
and table_name = '表名'
order by ordinal_position asc
版权属于：
香草物语
本文链接：
https://www.xiangcaowuyu.net/database/postgresql-view-column-information.html（转载时请注明本文出处及文章链接）
作品采用：
