Get table primary Key name in PostgreSQL database

get table primary key name in PostgreSQL database

First, to obtain the primary key information for the teacher table, as follows:

SelectPg_constraint.conname asPk_name,pg_attribute.attname asColname,pg_type.typname asTypeName fromPg_constraintInner JoinPg_class onPg_constraint.conrelid=pg_class.oidInner JoinPg_attribute onPg_attribute.attrelid=pg_class.oid andPg_attribute.attnum=Pg_constraint.conkey[1]Inner JoinPg_type onPg_type.oid=Pg_attribute.atttypidwherePg_class.relname= 'Teacher'  andPg_constraint.contype='P'

Two:

By graph, the name of the primary KEY constraint is pk_teacher, the primary key field (column) is ID, and the primary key field is the type: UUID.

--Song Xingju was published on July 30, 2015 in Jinan middle di zhi industry.

Get table primary Key name in PostgreSQL database