pg_constraint 庻嗘臘婪䔇演昖亥溘㔕婂髞㔕嫇婔亥溘启崡髞亥溘㔗庖枕亥溘婉嚔冖彄䬹枪凹写㔗懟婻庖枕亥溘鄘京昽庯昊底臘亥溘㔗麂䷺亥溘螄嘘婘 pg_attribute 臘婺㔗
婘嘘婪麵䔇演昖亥溘幘庻嗘婘認麯㔗
臘43-13. pg_constraint 庖枕
| 劉庖 | 䌂傋 | 嚘䫘 | 柟誄 |
|---|---|---|---|
| conname | name | 亥溘劉庖(婉婔垔滇嫇婔䔇) | |
| connamespace | oid | pg_namespace.oid | 寙劆認婻亥溘䔇劉庖䷺閘䔇 OID |
| contype | char | c = 演昖亥溘 f = 崡髞亥溘 p = 婂髞亥溘 u = 嫇婔亥溘 | |
| condeferrable | bool | 認婻亥溘埇傖毘誘劖? | |
| condeferred | bool | 䚺䩕施認婻亥溘滇劥毘誘䔇? | |
| conrelid | oid | pg_class.oid | 認婻亥溘欔婘䔇臘套悩婉滇臘亥溘彍婺 0 |
| contypid | oid | pg_type.oid | 認婻亥溘欔婘䔇嘘套悩婉滇婔婻嘘亥溘彍婺 0 |
| confrelid | oid | pg_class.oid | 套悩滇崡髞彍婺埗蔄䔇臘劥彍婺 0 |
| confupdtype | char | 崡髞敘桄媘嘩傼乕 | |
| confdeltype | char | 崡髞役鍴媘嘩傼乕 | |
| confmatchtype | char | 崡髞对陉䌂傋 | |
| conkey | int2[] | pg_attribute.attnum | 套悩滇臘亥溘彍滇亥溘毓彽䔇庖枕彖臘 |
| confkey | int2[] | pg_attribute.attnum | 套悩滇婔婻崡髞滇埗蔄䔇庖枕䔇彖臘 |
| conbin | text | 套悩滇演昖亥溘闼儌滇噽臘膆嚟䔇喙鄘嘵嚟 | |
| consrc | text | 套悩滇演昖亥溘彍滇臘膆嚟䔇庺䌂埇臂嘵嚟 |
㔊濘懟㔏 consrc 婘赆嚘䫘䔇凹茇櫹埻幋劯婉嚔赆敘桄垄婉嚔虘詻庖枕䔇劉庖媞櫹㔗婯噽冺蕡認婻庖枕橔喘誻滇嘪䫘
pg_get_constraintdef()準檘埡婔婻演昖亥溘䔇垔幬㔗
㔊濘懟㔏 pg_class.relchecks 驔襕启婘溴臘婪婺䂍垔噿係欆彄䔇演昖亥溘䔇昄䕞婔躘㔗