pg_prepared_statements 滆䴺欔橬嘷嬉嚔臺婺埇䫘䔇鵇崺臺埖㔗埗蓕 PREPARE 诙埡噿庯鵇崺臺埖䔇敘崔媇敇㔗
懟婻鵇崺臺埖婘 pg_prepared_statements 婺鄘橬凹庫䔇婔溇螄嘘㔗嘷婔溇桄䔇鵇崺臺埖录傺劯臖蓖商婺儌嚔桄嵂婔溇螄嘘劯湙嘷婔溇鵇崺臺埖赆麪櫆劯(懫套锔誺 DEALLOCATE 变傴)䕩庫䔇螄嘘幘嚔赆役鍴㔗
臘43-40. pg_prepared_statements 庖枕
| 劉庖 | 䌂傋 | 柟誄 |
|---|---|---|
| name | text | 鵇崺臺埖䔇湺臖严 |
| statement | text | 录傺臖鵇崺臺埖䔇昖臵庖严婾㔗凹庯傯 SQL 录傺䔇鵇崺臺埖蔯蘔滇垵潙䆇柊庴䔇 PREPARE 臺埖㔗凹庯锔誺嬉/劯䆇剟螞录傺䔇鵇崺臺埖蔯蘔滇鵇崺臺埖躻躆䔇桺橸㔗 |
| prepare_time | timestamptz | 录傺臖鵇崺臺埖䔇施閘潿 |
| parameter_types | regtype[] | 臖鵇崺臺埖橘橕䔇埗昄䌂傋傖 regtype 䌂傋䔇昄䂇湚嚟庺䯄㔗婯臖昄䂇噄䘹䕩凹庫䔇 OID 埇傖锔誺檪 regtype 唚蘸扵婺 oid 唚冖彄㔗 |
| from_sql | boolean | 套悩臖鵇崺臺埖滇锔誺 PREPARE 臺埖录傺䔇彍婺 true 套悩滇锔誺嬉/劯䆇剟螞录傺䔇彍婺 false |
pg_prepared_statements 蓖商滇埻臂䔇㔗