SELECT A.SCHEMANAME,
A.TABLENAME,
D.ATTNAME,
REPLACE(REPLACE(REPLACE(FORMAT_TYPE(D.ATTTYPID, D.ATTTYPMOD),
'numeric',
'NUMBER'),
'character varying',
'VARCHAR2'),
'date',
'DATE') AS DATA_TYPE,
C.DESCRIPTION
FROM PG_TABLES A
INNER JOIN PG_CLASS B
ON A.TABLENAME = B.RELNAME
LEFT JOIN PG_CATALOG.PG_DESCRIPTION C
ON B.OID = C.OBJOID
LEFT JOIN PG_CATALOG.PG_ATTRIBUTE D
ON D.ATTRELID = C.OBJOID
AND D.ATTNUM = C.OBJSUBID
WHERE SCHEMANAME = '模式名'
AND A.TABLENAME LIKE '%表名称%'
AND D.ATTNUM > 0
ORDER BY A.TABLENAME ,D.ATTNUM