SQL 查询
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SELECT A.attnum, ( SELECT description FROM pg_catalog.pg_description WHERE objoid = A.attrelid AND objsubid = A.attnum ) AS descript, A.attname, ( select typname from pg_type where oid = A.atttypid) AS type, A.atttypmod AS data_type FROM pg_catalog.pg_attribute A WHERE 1 = 1 AND A.attrelid = ( SELECT oid FROM pg_class WHERE relname = '表名称' ) AND A.attnum > 0 AND NOT A.attisdropped ORDER BY A.attnum; |
效果如图



通过结构查询的方式学会了。