在pg_catalog表中找到的字段的NUMERIC精度和比例在哪里？

SELECT c.relname AS table_name, a.attname AS column_name, d.adsrc AS data_type, a.atttypmod AS data_type_mods
FROM pg_class c
JOIN pg_attribute a ON c.oid = a.attrelid
JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
WHERE c.relname = 'your_table_name'  -- 替换为你要查询的表名
ORDER BY table_name, column_name;