postgresql 查询表中所有字段名
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_attribut
原创
2021-01-20 15:04:46 ·
2955 阅读 ·
0 评论