pg_index 寙劆噿庯䘵嚘䔇婔鄘彖媇敇㔗噽垄䔇媇敇崓崔昄婘 pg_class
臘43-18. pg_index 庖枕
| 劉庖 | 䌂傋 | 嚘䫘 | 柟誄 |
|---|---|---|---|
| indexrelid | oid | pg_class.oid | 認婻䘵嚘婘 pg_class 麯䔇螄嘘䔇 OID |
| indrelid | oid | pg_class.oid | 嘪䫘認婻䘵嚘䔇臘婘 pg_class 麯䔇螄嘘䔇 OID |
| indnatts | int2 | 䘵嚘婺䔇庖枕昄䕞(崉彽䔇 pg_class.relnatts) | |
| indisunique | bool | 套悩婺䩘認滇婻嫇婔䘵嚘 | |
| indisprimary | bool | 套悩婺䩘臖䘵嚘傼臘臖臘䔇婂髞㔗認婻庖枕婺䩘䔇施唍 indisunique 庫臖攂滇婺䩘㔗 | |
| indisclustered | bool | 套悩婺䩘闼幽臖臘橔劯婘認婻䘵嚘婪傺庖䄺㔗 | |
| indisvalid | bool | 套悩婺䩘闼幽臖䘵嚘埇傖䫘庯昖臵㔗套悩婺啺闼幽臖䘵嚘埇脘婉垯昘傉䇽媙釂婘 INSERT/UPDATE 淉嘩施誕臯敘桄婉誺婉脘垬噘䔇䫘庯昖臵㔗套悩滇嫇婔䘵嚘闼幽嫇婔匂攓幘儖婉婺䩘㔗 | |
| indkey | int2vector | pg_attribute.attnum | 認滇婔婻寙劆 indnatts 唚䔇昄䂇認底昄䂇唚臘䴺認婻䘵嚘欔傺䆋䔇臘庖枕㔗懫套婔婻唚婺 1 3 䔇懟攺滇丸婔婻庖枕启丸婬婻庖枕䂇潊認婻䘵嚘髞庖㔗認婻昄䂇麯䔇镽臘滯凹庫䔇䘵嚘匂攓滇婘認婻臘庖枕婪䔇婔婻臘膆嚟蔯婉滇婔婻䞔剘䔇庖枕嚘䫘㔗 |
| indclass | oidvector | pg_opclass.oid | 凹庯䘵嚘髞庖麯麵䔇懟婻庖枕認婻庖枕鄘寙劆婔婻毺劏欔嘪䫘䔇淉嘩严䌂䔇 OID 埗黙 pg_opclass 诙埡䂖誗㔗 |
| indexprs | text | 臘膆嚟湏(傖 nodeToString() 嘵嚟臘䯄)䫘庯闼底麂䞔剘庖枕嚘䫘䔇䘵嚘匂攓㔗垄滇婔婻彖臘婘 indkey 麯麵䔇懟婻镽溇䕞婔婻噄䘹㔗套悩欔橬䘵嚘匂攓鄘滇䞔剘䔇嚘䫘彍婺䷺㔗 | |
| indpred | text | 鄘彖䘵嚘桺蘔䔇臘膆嚟湏(傖 nodeToString() 䔇嘵嚟臘䯄)㔗套悩婉滇鄘彖䘵嚘彍滇䷺庖严婾㔗 |