--pg拉取表字段注释
SELECT
C.relname,
col_description (A .attrelid, A .attnum) AS COMMENT,
format_type (A .atttypid, A .atttypmod) AS TYPE,
A .attname AS NAME,
A .attnotnull AS NOTNULL
FROM
pg_class AS C,
pg_attribute AS A,
pg_tables T
WHERE
A .attrelid = C .oid AND T.tablename=C.relname
AND A .attnum > 0 and T.schemaname = 'markting'
--mysql拉取表字段注释
SELECT table_schema,table_name,COLUMN_NAME,column_comment
FROM INFORMATION_SCHEMA.Columns
WHERE table_schema in ('schema1','schema2','schema3') and COLUMN_COMMENT = ''
--mysql拉取所有表注释
SELECT TABLE_NAME,TABLE_COMMENT FROM information_schema.TABLES WHERE table_schema='mammothcode';