用SQL语句获得PostgreSQL表的主键

 以下sql语句 用来显示PostgreSQL 表的表结构 包括
字段名称、字段类型、是否为主键 这些信息

select pg_constraint.conname as pk_name from pg_constraint  inner join pg_class 
 on pg_constraint.conrelid = pg_class.oid where pg_class.relname = 'yourtablename' and pg_constraint.contype='p'

这个可以显示yourtablename表的主键

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 = 'yourtablename' 
and pg_constraint.contype='p'

这个可以显示出主键名，和主键关联的字段名,和字段名类型