| PostgreSQL 8.1 婺桺桺懼PostgreSQL 婺啘 彽嘩 | ||||
|---|---|---|---|---|
| Prev | Fast Backward | Chapter 31. 媇敇昇嚟 | Fast Forward | Next |
蓖商 domains 寙劆垔幬婘嘷嬉昄扞康婺䔇欔橬嘘㔗
Table 31-13. domains 庖枕
| 劉庖 | 昄扞䌂傋 | 柟誄 |
|---|---|---|
| domain_catalog | sql_identifier | 寙劆認婻嘘䔇昄扞康劉庖攂滇嘷嬉昄扞康 |
| domain_schema | sql_identifier | 寙劆認婻嘘䔇昇嚟劉庖 |
| domain_name | sql_identifier | 嘘䔇劉庖 |
| data_type | character_data | 套悩認滇婔婻喙䘞䌂傋儌滇嘘䔇昄扞䌂傋套悩傡滇昊䓉昄䂇認施 埗黙蓖商 element_types儌滇 ARRAY㔗 劥彍滇 USER-DEFINED認婻施唍䌂傋婘 udt_name 启䕩噿䔇庖枕麯麵湺臖㔗 |
| character_maximum_length | cardinal_number | 套悩嘘滇婔婻庖严潡蔙嘉婾䌂傋認滇垔幬䔇橔崓阪庥噽垄昄扞䌂傋 潡蔙澇橬弄滯橔崓阪庥彍婺䷺㔗 |
| character_octet_length | cardinal_number | 套悩嘘橬婔婻庖严䌂傋認滇橔崓埇脘䔇庖誗阪庥認底庫臖婉滇 PostgreSQL 䫘潙襕拙媄䔇庋愙 噽垄䌂傋鄘滇䷺㔗 |
| character_set_catalog | sql_identifier | 锗䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| character_set_schema | sql_identifier | 锗䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| character_set_name | sql_identifier | 锗䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| collation_catalog | sql_identifier | 锗䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| collation_schema | sql_identifier | 锗䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| collation_name | sql_identifier | 锗䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| numeric_precision | cardinal_number | 套悩認婻嘘橬婔婻昄唚䌂傋闼幽認婻庖枕寙劆弄滯䔇潡锊劆䔇 䫘庯認婻庖枕䔇䌂傋來庥㔗來庥臘䴺橬昽昄扞嘉䔇婻昄㔗埇傖䫘剕誕彽 臘䴺幘埇傖䫘庯誕彽臘䴺儌愿婘 numeric_precision_radix 庖枕麯弄滯䔇闼湙㔗凹庯欔橬噽垄䌂傋認婻庖枕滇䷺㔗 |
| numeric_precision_radix | cardinal_number | 套悩認婻嘘橬婔婻昄唚䌂傋闼幽認婻庖枕湺臖numeric_precision 启 numeric_scale 庖枕䔇昄唚䔇嘺昄滇崔儏㔗昄唚 襕幽滇 2 襕幽滇 10㔗凹庯欔橬噽垄昄扞䌂傋認婻庖枕滇䷺㔗 |
| numeric_scale | cardinal_number | 套悩認婻嘘橬婔婻庖䇞䔇昄唚䌂傋闼幽認婻庖枕寙劆弄滯潡蔙锊劆䔇 橸庖枕臖䌂傋䔇懫冋㔗懫冋湺媖五償昄䗹埿膹䔇橬昽嘉昄㔗垄埇傖滇䫘 剕誕彽臘䴺幘埇傖䫘庯誕彽臘䴺儌償婘 numeric_precision_radix 庖枕麯弄滯䔇闼湙㔗凹庯欔橬噽垄昄扞䌂傋認婻庖枕滇䷺㔗 |
| datetime_precision | cardinal_number | 套悩臖嘘滇婔婻斖橘施閘潡蔙施閘閘锫䌂傋闼幽儌滇弄滯䔇來庥 凹庯噽垄昄扞䌂傋潡蔙澇橬弄滯來庥闼幽婺䷺㔗 |
| interval_type | character_data | 橻垂䯄 |
| interval_precision | character_data | 橻垂䯄 |
| domain_default | character_data | 認婻嘘䔇䚺䩕臘膆嚟 |
| udt_catalog | sql_identifier | 嘘昄扞䌂傋垔幬欔婘䔇昄扞康劉庖攂滇嘷嬉昄扞康 |
| udt_schema | sql_identifier | 嘘昄扞䌂傋垔幬欔婘䔇昇嚟劉庖 |
| udt_name | sql_identifier | 嘘昄扞䌂傋劉庖 |
| scope_catalog | sql_identifier | 锗䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| scope_schema | sql_identifier | 锗䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| scope_name | sql_identifier | 锗䫘庯婔婻PostgreSQL 麯澇橬䔇䬹攓 |
| maximum_cardinality | cardinal_number | 攂滇婺䷺啹婺PostgreSQL 䔇昄䂇攂滇橬方鍊䔇䂘昄 |
| dtd_identifier | sql_identifier | 婔婻臖嘘䔇昄扞䌂傋柟誄严䔇湺臖严婘匂庯臖嘘䔇欔橬昄扞䌂傋柟誄严 婺滇嫇婔䔇認婻滇䊊庋啹婺婔婻嘘埻寙劆婔䓉昄扞䌂傋㔗認婻婂襕 䫘庯启噽垄認湙䔇湺臖严垂冋誂毖㔗認婻湺臖严䔇噙嘷湚嚟澇橬垔幬 幽婫婉媺臕婘儖準䬽橸婺媺毕婔躘㔗 |