以下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' 这个可以显示出主键名,和主键关联的字段名,和字段名类型