摘要:
--判断表格是否存在,不存在则返回结果为null select distinct table_name from information_schema.columns where table_schema='schemaName' and table_name='tableName'; --根据表格 阅读全文
摘要:
//判断表中是否存在该字段 SELECT count(1) FROM ( //获取字段名方法一 SELECT attname FROM pg_catalog.pg_attribute WHERE attstattarget = - 1 AND attrelid IN ( SELECT oid FRO 阅读全文