Te_zzx_amo的博客

PG数据库和MYSQL数据库进行表的比对并输出相同和不同的表的数量

SELECT d.nspname AS "SchemaName", C.relname AS "表名", A.attnum AS "序号", A.attname AS "字段名称", format_type ( A.atttypid, A.atttypmod ) AS "字段类型", ( CASE WHEN A.attnotnull = TRUE THEN 'NOT NULL' ELSE'' END ) AS "是否非空", ( CASE WHEN ...