postgreSQL获取主键
select pg_constraint.conname as pk_name, pg_attribute.attname as colname, pg_type.typname as typename from pg_constraint inner join pg_class on pg_constraint.conrelid = pg_class.oid inner join pg_attribute on pg_attribute.attrelid = pg_class.oid and pg_attribute.attnum = pg_constraint.conkey[1] inner join pg_type on pg_type.oid = pg_attribute.atttypid where pg_class.relname = 'tableName' and pg_constraint.contype='p' and pg_table_is_visible(pg_class.oid) --表在搜索中可见
postgreSQL获取字段信息
SELECT 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 WHERE C.RELNAME = 'tableName' AND A.ATTRELID = C.OID AND A.ATTNUM > 0
本文作者为新逸网络,转载请注明。