pg_database 臘庻嗘噿庯埇䫘昄扞康䔇媇敇㔗昄扞康滇䫘 CREATE DATABASE 录傺䔇㔗埗蔄䆹19诙埡婔底埗昄䔇臥䂖劆幬㔗
启崓崔昄係䂘臘婉劯pg_database 滇婘婔婻镖䆴麯䔇欔橬昄扞康噌庆䔇懟婻镖䆴埻橬婔傘 pg_database 拙蘺蔯婉滇懟婻昄扞康婔傘㔗
臘43-15. pg_database 庖枕
| 劉庖 | 䌂傋 | 嚘䫘 | 柟誄 |
|---|---|---|---|
| datname | name | 昄扞康劉庖 | |
| datdba | oid | pg_authid.oid | 昄扞康欔橬庺锔婩婺噽录傺蔙 |
| encoding | int4 | 昄扞康䔇庖严䚡乕桹嚟(pg_encoding_to_char() 脘崘儖認婻昄庖蘸扵婺䕩庫䔇䚡乕劉䓄) | |
| datistemplate | bool | 套悩婺䩘彍溴昄扞康埇傖䫘庯 CREATE DATABASE 䔇 TEMPLATE 床埖檪桄昄扞康录傺婺溴昄扞康䔇噋锖㔗 | |
| datallowconn | bool | 套悩婺啺彍澇橬庺埇傖誂毖彄認婻昄扞康㔗認婻庖枕䫘庯媺檴 template0 昄扞康婉赆敘櫹㔗 | |
| datconnlimit | int4 | 螆䘞臖昄扞康婪噕螩䔇橔崓幽埏誂毖昄-1 臘䴺方鍊彽㔗 | |
| datlastsysoid | oid | 昄扞康麯橔劯婔婻係䂘 OID 凹 pg_dump 䬹彆橬䫘㔗 | |
| datfrozenxid | xid | 臖昄扞康婺婺欔橬婘認婻幋嬉䔇庋媇 ID 噾䂟赆婔婻啺垔䔇("frozen")庋媇 ID 敪扵㔗認䫘庯虘詻臖昄扞康滇劥驔襕婺庖黾溵庋媇 ID 麉培潡蔙噕螩櫽䚷 pg_clog 蔯誕臯橙䊖㔗垄滇鐽凹懟婻臘䔇 pg_class.relfrozenxid 婺䔇橔償唚㔗 | |
| dattablespace | oid | pg_tablespace.oid | 臖昄扞康䔇䚺䩕臘䷺閘㔗婘認婻昄扞康麯欔橬 pg_class.reltablespace 婺镽䔇臘鄘儖媺庻婘認婻臘䷺閘麯䬹彆襕毺庺䔇滇欔橬麂噌庆䔇係䂘臘幘鄘庻櫆婘認麯㔗 |
| datconfig | text[] | 誊臯施陉䘞埻麟䔇嚔臺䚺䩕唚 | |
| datacl | aclitem[] | 螪閞溄鍊埗黙 GRANT 启 REVOKE 诙埡臥䂖柟誄㔗 |