摘要:
SELECT c.relname AS "表名",a.attname AS "字段名",c.oidFROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oidWHERE c.relname NOT LIKE 'pg_%'-- AND c 阅读全文
摘要:
select constraint_name,constraint_type,table_name from all_constraints where CONSTRAINT_NAME='PK_ID';PS:转自:https://www.cnblogs.com/kingxiaozi/p/470866 阅读全文