罗名岳
发布于

查看表结构的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 = 'sales' 
  AND A.attnum > 0 
  AND A.attrelid = C.oid 
  AND A.atttypid = T.oid 
ORDER BY 
  A.attnum;

其中 sales 是表名

评论
    test