SELECT a.attnum,a.attname AS field,t.typname AS type,a.attlen AS length,
a.atttypmod AS lengthvar,a.attnotnull AS notnull
from pg_class c,pg_attribute a,pg_type t where c.relname='t_approve_auditor'
and a.attnum>0 and a.attrelid=c.oid and a.atttypid=t.oid
posgresql 查询表结构
最新推荐文章于 2024-04-28 20:42:45 发布