PostgreSQL 9.6.0 锟街诧拷
锟斤拷一页锟斤拷一锟斤拷锟斤拷 36. 锟斤拷展 SQL锟斤拷一页

36.15. 锟斤拷锟斤拷锟截讹拷锟斤拷一锟斤拷锟斤拷展锟斤拷

一锟斤拷锟斤拷PostgreSQL锟斤拷锟矫碉拷锟斤拷展通锟斤拷锟斤拷锟斤拷锟斤拷锟� SQL 锟斤拷锟斤拷锟斤拷锟界，一锟斤拷锟铰碉拷锟斤拷锟斤拷锟斤拷锟酵斤拷锟斤拷要锟铰猴拷锟斤拷锟斤拷锟铰诧拷锟斤拷锟斤拷锟皆硷拷锟斤拷锟杰碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟洁。锟斤拷锟斤拷锟斤拷锟斤拷些锟斤拷锟斤拷锟秸硷拷锟斤拷一锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟节硷拷锟斤拷锟捷匡拷锟斤拷锟斤拷锟�PostgreSQL锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷为一锟斤拷锟斤拷展锟斤拷要锟斤拷锟斤拷一锟斤拷锟斤拷展锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷要一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷展锟侥讹拷锟斤拷锟�SQL锟斤拷锟斤拷锟�锟脚憋拷锟侥硷拷锟皆硷拷一锟斤拷指锟斤拷锟斤拷展锟斤拷锟斤拷锟斤拷一些锟斤拷锟斤拷锟斤拷锟皆碉拷锟斤拷锟斤拷锟侥硷拷锟斤拷锟斤拷锟斤拷锟秸癸拷锟斤拷锟� C 锟斤拷锟诫，通锟斤拷锟斤拷锟斤拷一锟斤拷 C 锟斤拷锟斤拷锟斤拷锟斤拷锟缴的癸拷锟斤拷锟斤拷锟侥硷拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷些锟侥硷拷锟斤拷一锟斤拷锟津单碉拷CREATE EXTENSION锟斤拷锟斤拷锟斤拷园锟斤拷锟叫╋拷锟斤拷锟斤拷锟斤拷氲斤拷锟斤拷锟斤拷锟捷库。

使锟斤拷一锟斤拷锟斤拷展锟斤拷锟斤拷锟斤拷只锟斤拷锟斤拷SQL锟脚憋拷锟斤拷锟斤拷一锟斤拷"锟斤拷散"锟斤拷锟斤拷锟斤拷锟捷匡拷锟斤拷锟揭拷诺锟斤拷牵锟�PostgreSQL锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟秸癸拷亩锟斤拷锟斤拷锟揭伙拷锟侥★拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟揭伙拷锟�DROP EXTENSION锟斤拷锟斤拷删锟斤拷锟斤拷锟叫的讹拷锟襟（诧拷锟斤拷维锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷"卸锟斤拷"锟脚憋拷锟斤拷锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟矫碉拷一锟斤拷锟角ｏ拷pg_dump知锟斤拷锟斤拷锟斤拷应锟斤拷转锟斤拷锟斤拷锟斤拷展锟叫的革拷锟斤拷锟皆憋拷锟斤拷锟� — 锟斤拷锟斤拷只锟斤拷转锟斤拷锟叫帮拷锟斤拷一锟斤拷CREATE EXTENSION锟斤拷锟筋。锟斤拷锟斤拷锟斤拷锟角拷频锟揭伙拷锟斤拷锟斤拷锟斤拷锟酵拷诰砂锟斤拷锟秸癸拷卸锟斤拷锟斤拷锟铰帮拷锟斤拷展锟侥癸拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷注锟斤拷锟节帮拷锟斤拷锟斤拷一锟斤拷转锟斤拷锟斤拷锟诫到一锟斤拷锟斤拷锟斤拷锟捷匡拷时锟斤拷锟斤拷锟斤拷展锟侥匡拷锟狡★拷锟脚憋拷锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷锟斤拷锟斤拷谩锟�

PostgreSQL锟斤拷锟斤拷锟斤拷锟斤拷删锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷展锟叫的革拷锟斤拷锟斤拷螅锟斤拷锟缴撅拷锟斤拷锟斤拷锟斤拷锟秸癸拷锟斤拷锟斤拷校锟斤拷锟饺伙拷锟斤拷芄锟斤拷谋锟揭伙拷锟斤拷锟秸癸拷某锟皆憋拷锟斤拷锟侥讹拷锟藉（锟斤拷锟界，通锟斤拷CREATE OR REPLACE FUNCTION锟侥憋拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷住锟斤拷锟睫改猴拷亩锟斤拷褰拷锟斤拷岜�pg_dump转锟斤拷锟斤拷锟斤拷锟街改憋拷通锟斤拷只锟斤拷锟斤拷锟姐并锟斤拷锟斤拷锟斤拷锟斤拷展锟脚憋拷锟侥硷拷锟斤拷锟斤拷锟斤拷锟斤拷同锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟藉（锟斤拷锟角讹拷锟节帮拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷的憋拷锟斤拷锟斤拷锟斤拷墓娑拷锟斤拷锟�锟斤拷 36.15.3 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫ｏ拷通锟斤拷锟斤拷锟矫的凤拷式锟角达拷锟斤拷一锟斤拷锟斤拷展锟斤拷锟铰脚憋拷锟斤拷执锟叫讹拷锟斤拷展锟叫筹拷员锟斤拷锟斤拷母锟斤拷摹锟�

锟斤拷展锟脚憋拷锟斤拷锟杰伙拷通锟斤拷GRANT锟斤拷REVOKE锟斤拷锟斤拷锟斤拷锟斤拷锟秸癸拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷权锟斤拷每一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟饺拷锟斤拷希锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿猴拷锟斤拷权锟斤拷锟斤拷锟斤拷锟芥储锟斤拷pg_init_privs系统目录锟叫★拷使锟斤拷pg_dump时锟斤拷CREATE EXTENSION锟斤拷锟筋将锟斤拷锟斤拷锟斤拷锟斤拷转锟斤拷锟叫ｏ拷锟斤拷锟斤拷锟斤拷锟脚憋拷要锟斤拷GRANT锟斤拷REVOKE锟斤拷浼拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷权锟斤拷锟矫筹拷取锟矫革拷转锟斤拷时锟斤拷锟斤拷锟接★拷

PostgreSQL锟斤拷前锟斤拷支锟斤拷锟斤拷展锟脚憋拷锟斤拷锟斤拷CREATE POLICY锟斤拷锟斤拷SECURITY LABEL锟斤拷洹ｏ拷锟叫╋拷锟斤拷锟斤拷锟斤拷锟斤拷锟接︼拷锟斤拷锟斤拷锟秸癸拷锟斤拷锟斤拷锟斤拷锟街拷锟斤拷锟斤拷锟斤拷小锟斤拷锟斤拷锟斤拷锟斤拷锟秸癸拷锟斤拷锟斤拷洗锟斤拷锟斤拷锟� RLS 锟斤拷锟皆和帮拷全锟斤拷签锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷pg_dump锟斤拷锟斤拷锟斤拷转锟斤拷锟叫★拷

锟斤拷展锟斤拷锟斤拷也锟皆达拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟秸癸拷锟斤拷锟斤拷锟� SQL 锟斤拷锟斤拷锟斤拷锟斤拷薷慕疟锟斤拷泄娑拷锟斤拷锟斤拷纾拷锟斤拷一锟斤拷锟斤拷展锟斤拷 1.1 锟芥本锟斤拷 1.0 锟芥本锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟揭革拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟侥猴拷锟斤拷锟藉，锟斤拷锟斤拷展锟斤拷锟斤拷锟竭匡拷锟斤拷锟结供一锟斤拷锟斤拷锟铰脚憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟侥★拷锟斤拷么ALTER EXTENSION UPDATE锟斤拷锟斤拷锟斤拷员锟斤拷锟斤拷锟接︼拷锟斤拷锟叫╋拷锟斤拷牟锟斤拷腋锟斤拷锟斤拷诟锟斤拷锟斤拷锟斤拷菘锟斤拷锟绞碉拷拾锟阶帮拷锟斤拷歉锟斤拷锟秸癸拷锟斤拷母锟斤拷姹撅拷锟�

锟斤拷锟斤拷为一锟斤拷锟斤拷展锟侥筹拷员锟斤拷 SQL 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�ALTER EXTENSION锟斤拷示锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷库集锟截凤拷围锟侥讹拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷库、锟斤拷色锟酵憋拷锟秸间）锟斤拷锟斤拷锟斤拷为锟斤拷展锟斤拷员锟斤拷锟斤拷为一锟斤拷锟斤拷展只锟斤拷一锟斤拷锟斤拷锟捷库范围锟节可硷拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷展锟脚憋拷锟斤拷没锟叫憋拷锟斤拷止锟斤拷锟斤拷锟斤拷些锟斤拷锟襟，碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟睫凤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟斤拷展锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟劫ｏ拷锟斤拷锟斤拷要注锟斤拷锟斤拷然一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷展锟侥筹拷员锟斤拷锟斤拷锟侥凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟结被直锟斤拷锟斤拷为锟角革拷锟斤拷展锟侥筹拷员锟斤拷锟斤拷一锟斤拷锟截碉拷锟斤拷模式锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷展锟斤拷锟斤拷锟角凤拷锟斤拷锟斤拷锟斤拷锟叫ｏ拷一锟斤拷锟斤拷展锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟睫讹拷锟斤拷锟斤拷锟狡诧拷锟揭诧拷锟斤拷锟斤拷锟斤拷锟轿猴拷模式"锟斤拷"锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷展锟侥筹拷员锟斤拷锟斤拷只要锟斤拷锟斤拷锟斤拷锟酵猴拷锟绞就匡拷锟斤拷锟斤拷锟斤拷模式锟斤拷一锟斤拷锟斤拷展拥锟叫帮拷锟斤拷锟斤拷锟皆憋拷锟斤拷锟斤拷模式锟斤拷锟杰猴拷锟斤拷也锟斤拷锟杰诧拷锟斤拷锟绞★拷

36.15.1. 锟斤拷展锟侥硷拷

CREATE EXTENSION锟斤拷锟斤拷锟斤拷锟斤拷每一锟斤拷锟斤拷展锟斤拷锟叫的匡拷锟斤拷锟侥硷拷锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷锟诫被锟斤拷锟斤拷为锟斤拷展锟斤拷锟斤拷锟狡硷拷锟斤拷一锟斤拷锟斤拷缀.control锟斤拷锟斤拷锟揭憋拷锟诫被锟斤拷锟节帮拷装锟斤拷SHAREDIR/extension目录锟叫★拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷SQL锟脚憋拷锟侥硷拷锟斤拷锟斤拷锟斤拷循锟斤拷锟斤拷模式extension--version.sql锟斤拷锟斤拷锟界，foo--1.0.sql锟斤拷示锟斤拷展foo锟斤拷1.0锟芥本锟斤拷锟斤拷默锟斤拷锟斤拷锟斤拷拢锟斤拷疟锟斤拷募锟揭诧拷锟斤拷锟斤拷锟斤拷锟�SHAREDIR/extension目录锟叫ｏ拷锟斤拷锟角匡拷锟斤拷锟侥硷拷锟叫匡拷锟斤拷为锟脚憋拷锟侥硷拷指锟斤拷一锟斤拷锟斤拷同锟斤拷目录锟斤拷

一锟斤拷锟斤拷展锟斤拷锟斤拷锟侥硷拷锟侥革拷式锟斤拷postgresql.conf锟侥硷拷锟斤拷同锟斤拷锟斤拷锟斤拷一锟斤拷parameter_name = value锟斤拷值锟斤拷锟叫憋拷锟斤拷每锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫猴拷#锟斤拷锟斤拷锟阶拷汀锟阶拷锟斤拷锟轿何诧拷锟角碉拷一锟绞伙拷锟斤拷锟街碉拷值锟斤拷锟斤拷锟斤拷锟脚★拷

一锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫诧拷锟斤拷锟斤拷

directory (string)

锟斤拷锟斤拷锟斤拷展锟斤拷SQL锟脚憋拷锟侥硷拷锟斤拷目录锟斤拷锟斤拷锟角革拷锟斤拷一锟斤拷锟斤拷锟斤拷路锟斤拷锟斤拷锟斤拷锟侥柯硷拷锟斤拷锟斤拷锟斤拷锟节帮拷装锟斤拷SHAREDIR目录锟斤拷默锟斤拷锟斤拷为锟斤拷效锟斤拷指锟斤拷directory = 'extension'锟斤拷

default_version (string)

锟斤拷锟斤拷展锟斤拷默锟较版本锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�CREATE EXTENSION锟斤拷没锟斤拷指锟斤拷锟芥本时锟斤拷锟结被锟斤拷装锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟杰匡拷锟皆猴拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷没锟叫筹拷锟斤拷VERSION选锟斤拷时锟角斤拷锟结导锟斤拷CREATE EXTENSION失锟杰ｏ拷锟斤拷锟斤拷锟酵拷锟斤拷锟斤拷锟较ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟�

comment (string)

一锟斤拷锟斤拷锟节革拷锟斤拷展锟斤拷注锟酵ｏ拷锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷注锟酵伙拷锟节筹拷始锟斤拷锟斤拷锟斤拷展时应锟矫ｏ拷锟斤拷锟斤拷锟斤拷展锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟矫革拷注锟酵ｏ拷锟斤拷为锟斤拷锟杰会覆锟斤拷锟矫伙拷锟斤拷锟接碉拷注锟酵ｏ拷锟斤拷锟斤拷展锟斤拷注锟斤拷也锟斤拷锟斤拷通锟斤拷锟节脚憋拷锟侥硷拷锟斤拷写锟斤拷COMMENT锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷

encoding (string)

锟矫脚憋拷锟侥硷拷使锟矫碉拷锟街凤拷锟斤拷锟斤拷锟诫。锟斤拷锟脚憋拷锟侥硷拷锟斤拷锟斤拷锟轿何凤拷 ASCII 锟街凤拷时锟斤拷锟斤拷锟斤拷指锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷募锟斤拷锟斤拷岜伙拷俣锟轿拷锟斤拷菘锟斤拷锟诫。

module_pathname (string)

锟斤拷锟斤拷锟斤拷锟斤拷锟街碉拷锟斤拷锟斤拷锟斤拷锟斤拷婊伙拷疟锟斤拷募锟斤拷锟矫恳伙拷纬锟斤拷值锟�MODULE_PATHNAME锟斤拷锟斤拷锟斤拷锟斤拷茫锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟芥换锟斤拷通锟斤拷锟斤拷锟斤拷岜伙拷锟斤拷锟轿�$libdir/shared_library_name锟斤拷锟揭斤拷锟斤拷MODULE_PATHNAME锟斤拷锟斤拷锟斤拷CREATE FUNCTION锟斤拷锟斤拷锟叫斤拷锟斤拷 C-锟斤拷锟皆猴拷锟斤拷锟侥达拷锟斤拷锟斤拷锟斤拷烁媒疟锟斤拷募锟斤拷锟斤拷匕压锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷硬锟斤拷锟斤拷锟斤拷锟斤拷锟叫★拷

requires (string)

锟斤拷锟斤拷锟秸癸拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟秸癸拷锟斤拷锟揭伙拷锟斤拷斜锟斤拷锟斤拷锟斤拷锟�requires = 'foo, bar'锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷展锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟秸癸拷锟阶帮拷锟�

superuser (boolean)

锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为true锟斤拷默锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷谐锟斤拷锟斤拷没锟斤拷芄锟斤拷锟斤拷锟斤拷锟斤拷锟秸癸拷锟斤拷呓锟斤拷锟斤拷锟斤拷碌锟揭伙拷锟斤拷掳姹撅拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为false锟斤拷只锟斤拷要锟斤拷锟斤拷执锟叫帮拷装锟斤拷锟斤拷锟斤拷锟斤拷吒锟斤拷陆疟锟斤拷锟斤拷锟饺拷锟�

relocatable (boolean)

锟斤拷锟揭伙拷锟斤拷锟秸癸拷锟斤拷锟斤拷诔锟绞硷拷锟斤拷锟街拷锟斤拷锟斤拷锟斤拷锟斤拷亩锟斤拷锟斤拷贫锟斤拷锟揭伙拷锟斤拷锟酵拷锟侥Ｊ斤拷校锟斤拷锟斤拷锟斤拷锟�relocatable锟斤拷默锟斤拷值锟斤拷false锟斤拷锟斤拷锟斤拷锟斤拷展锟角诧拷锟斤拷锟截讹拷位锟侥★拷锟斤拷锟�锟斤拷 36.15.2 锟斤拷锟斤拷

schema (string)

锟斤拷锟斤拷锟斤拷锟街伙拷锟轿拷强锟斤拷囟锟轿伙拷锟秸癸拷锟斤拷谩锟斤拷锟角匡拷锟斤拷锟秸癸拷锟斤拷锟斤拷氲斤拷锟斤拷锟斤拷锟侥Ｊ斤拷卸锟斤拷锟斤拷锟斤拷锟侥Ｊ斤拷小锟街伙拷锟斤拷诔锟绞硷拷锟斤拷锟揭伙拷锟斤拷锟秸故憋拷呕锟轿匡拷schema锟斤拷锟斤拷锟斤拷锟斤拷展锟斤拷锟斤拷时锟津不伙拷慰锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�锟斤拷 36.15.2 锟斤拷锟斤拷

锟斤拷锟斤拷锟斤拷要锟斤拷锟斤拷锟侥硷拷extension.control锟斤拷一锟斤拷锟斤拷展锟斤拷锟斤拷锟斤拷锟叫讹拷锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷锟斤拷锟斤拷锟斤拷extension--version.control锟侥凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟结供锟剿讹拷锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷锟斤拷锟角憋拷锟诫被锟斤拷锟斤拷锟节脚憋拷锟侥硷拷锟斤拷目录锟叫★拷锟斤拷锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷循锟斤拷要锟斤拷锟斤拷锟侥硷拷锟斤拷同锟侥革拷式锟斤拷锟节帮拷装锟斤拷锟斤拷赂锟斤拷锟秸癸拷陌姹臼憋拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷募锟斤拷锟斤拷锟斤拷玫锟斤拷魏尾锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭拷锟斤拷锟斤拷募锟斤拷械锟斤拷锟斤拷谩锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�directory锟皆硷拷default_version锟斤拷锟斤拷锟节讹拷锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷锟斤拷锟矫★拷

一锟斤拷锟斤拷展锟斤拷SQL锟脚憋拷锟侥硷拷锟杰癸拷锟斤拷锟斤拷锟轿猴拷 SQL 锟斤拷锟筋，锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷睿�BEGIN锟斤拷COMMIT锟饺ｏ拷锟皆硷拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟街达拷械锟斤拷锟斤拷睿拷锟�VACUUM锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟脚憋拷锟侥硷拷锟结被锟斤拷式锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷斜锟街达拷小锟�

一锟斤拷锟斤拷展锟斤拷SQL锟脚憋拷锟侥硷拷也锟杰帮拷锟斤拷锟斤拷\echo锟斤拷始锟斤拷锟叫ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷展锟斤拷锟狡猴拷锟皆ｏ拷锟斤拷锟斤拷注锟酵ｏ拷锟斤拷锟斤拷锟斤拷疟锟斤拷募锟斤拷锟斤拷透锟�psql锟斤拷锟斤拷锟斤拷锟斤拷CREATE EXTENSION锟斤拷锟诫（锟斤拷锟斤拷 36.15.5 锟斤拷锟叫碉拷示锟斤拷锟脚憋拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷通锟斤拷锟斤拷锟斤拷锟斤拷锟阶筹拷锟斤拷锟斤拷锟斤拷锟矫伙拷锟斤拷锟斤拷止锟斤拷埽锟斤拷没锟斤拷锟斤拷芑锟斤拷锟斤拷锟截把革拷锟斤拷展锟斤拷锟斤拷锟斤拷锟斤拷为"锟斤拷散锟斤拷"锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟秸癸拷锟斤拷耄拷锟斤拷锟斤拷锟阶刺拷指锟斤拷锟斤拷锟斤拷冉锟斤拷榉筹拷锟�

锟斤拷锟杰脚憋拷锟侥硷拷锟斤拷锟皆帮拷锟斤拷指锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿猴拷锟街凤拷锟斤拷锟斤拷锟角匡拷锟斤拷锟侥硷拷应锟斤拷只锟斤拷锟斤拷锟斤拷 ASCII 锟街凤拷锟斤拷锟斤拷为PostgreSQL没锟叫办法知锟斤拷一锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷什么锟斤拷锟诫。实锟斤拷锟较ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟秸癸拷锟阶拷锟斤拷锟绞癸拷梅锟� ASCII 锟街凤拷只锟斤拷一锟斤拷锟斤拷锟解。锟狡硷拷锟侥凤拷锟斤拷锟角诧拷使锟矫匡拷锟斤拷锟侥硷拷锟斤拷comment锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷使锟矫脚憋拷锟侥硷拷锟叫碉拷COMMENT ON EXTENSION锟斤拷锟斤拷锟斤拷注锟酵★拷

36.15.2. 锟斤拷展锟斤拷锟劫讹拷位锟斤拷

锟矫伙拷锟斤拷锟斤拷希锟斤拷锟斤拷锟斤拷展锟叫帮拷锟斤拷锟侥讹拷锟斤拷锟斤拷锟诫到一锟斤拷锟斤拷锟斤拷展锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷牟锟揭伙拷锟斤拷锟侥Ｊ斤拷小锟斤拷锟斤拷锟斤拷锟斤拷挚锟斤拷囟锟轿伙拷裕锟斤拷锟斤拷锟斤拷锟街э拷值募锟斤拷锟�

锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷拢锟斤拷疟锟斤拷募锟斤拷锟斤拷锟斤拷锟�search_path执锟叫ｏ拷锟斤拷锟斤拷锟斤拷岜伙拷锟斤拷锟轿革拷锟侥匡拷锟侥Ｊ斤拷锟揭诧拷锟斤拷锟剿�CREATE EXTENSION锟斤拷锟斤拷也锟角碉拷效锟侥癸拷锟斤拷锟斤拷 

SET LOCAL search_path TO @extschema@;

锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷疟锟斤拷募锟斤拷锟斤拷锟斤拷亩锟斤拷锟斤拷锟诫到目锟斤拷模式锟叫★拷锟斤拷锟斤拷疟锟斤拷募锟较ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷愿谋锟�search_path锟斤拷锟斤拷锟斤拷锟斤拷锟矫凤拷通锟斤拷锟角诧拷锟杰伙拷迎锟侥★拷锟斤拷CREATE EXTENSION锟斤拷锟斤拷锟斤拷search_path锟结被锟街革拷锟斤拷之前锟斤拷锟斤拷锟矫★拷

锟斤拷锟斤拷锟斤拷锟斤拷募锟斤拷懈锟斤拷锟斤拷锟�schema锟斤拷锟斤拷锟斤拷目锟斤拷模式锟斤拷锟缴该诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷目锟斤拷模式锟斤拷CREATE EXTENSION锟斤拷SCHEMA选锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟竭讹拷没锟叫革拷锟斤拷锟斤拷锟斤拷玫锟角澳拷系亩锟斤拷蟠唇锟侥Ｊ斤拷锟斤拷诘锟斤拷锟斤拷锟�search_path锟叫的碉拷一锟斤拷锟斤拷锟斤拷锟斤拷使锟斤拷锟斤拷展锟侥硷拷锟斤拷schema锟斤拷锟斤拷时锟斤拷锟斤拷锟侥匡拷锟侥Ｊ斤拷锟斤拷锟斤拷锟斤拷诮锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟窖撅拷锟斤拷锟节★拷

锟斤拷锟斤拷诳锟斤拷锟斤拷募锟斤拷械锟�requires锟斤拷锟叫撅拷锟斤拷锟轿猴拷锟饺碉拷锟斤拷展锟斤拷锟斤拷锟角碉拷目锟斤拷模式锟结被追锟接碉拷search_path锟侥筹拷始锟斤拷锟斤拷锟叫★拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷展锟侥脚憋拷锟侥硷拷锟杰癸拷锟斤拷锟斤拷锟斤拷锟角的讹拷锟斤拷

锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟截讹拷位锟斤拷锟斤拷展锟杰癸拷锟斤拷锟斤拷散锟斤拷锟节讹拷锟侥Ｊ斤拷械亩锟斤拷锟酵拷锟斤拷锟斤拷锟街碉拷媒锟斤拷锟酵硷拷锟斤拷锟斤拷獠渴癸拷玫锟斤拷锟斤拷卸锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷模式锟叫ｏ拷锟解被锟斤拷为锟角革拷锟斤拷展锟斤拷目锟斤拷模式锟斤拷锟斤拷锟斤拷一锟街帮拷锟脚匡拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷展锟斤拷锟斤拷锟斤拷锟斤拷锟叫凤拷锟斤拷锟斤拷锟�search_path锟斤拷默锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷

36.15.3. 锟斤拷展锟斤拷锟矫憋拷

某些锟斤拷展锟斤拷锟斤拷锟斤拷锟矫憋拷锟斤拷锟斤拷锟叫帮拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫伙拷锟斤拷锟斤拷展锟斤拷装锟斤拷锟斤拷锟接伙拷锟睫改碉拷锟斤拷锟捷★拷通锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟秸癸拷锟揭伙拷锟斤拷郑锟斤拷帽锟斤拷亩锟斤拷锟斤拷锟斤拷锟捷讹拷锟斤拷锟结被pg_dump转锟斤拷锟斤拷锟斤拷锟角讹拷锟斤拷一锟斤拷锟斤拷锟矫憋拷锟斤拷说锟斤拷锟斤拷希锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟斤拷锟轿猴拷锟矫伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟睫改讹拷锟斤拷要锟斤拷锟斤拷锟斤拷锟斤拷转锟斤拷锟叫ｏ拷锟斤拷锟斤拷锟斤拷锟秸癸拷锟斤拷锟斤拷锟街拷锟斤拷锟斤拷为锟斤拷锟斤拷转锟斤拷之前锟斤拷同锟斤拷

要锟斤拷锟斤拷锟斤拷锟斤拷锟解，一锟斤拷锟斤拷展锟侥脚憋拷锟侥硷拷锟斤拷锟皆帮拷一锟斤拷锟斤拷锟斤拷锟斤拷锟侥憋拷锟斤拷锟斤拷锟斤拷锟叫憋拷锟轿拷锟斤拷霉锟较碉拷锟斤拷饨拷锟斤拷锟�pg_dump锟窖该憋拷锟斤拷锟斤拷锟斤拷锟叫碉拷锟斤拷锟捷ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟侥讹拷锟藉）锟斤拷锟斤拷锟斤拷转锟斤拷锟叫★拷要锟斤拷锟斤拷锟斤拷锟斤拷锟节达拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷之锟斤拷锟斤拷煤锟斤拷锟�pg_extension_config_dump(regclass, text)锟斤拷锟斤拷锟斤拷 

CREATE TABLE my_config (key text, value text);
CREATE SEQUENCE my_config_seq;

SELECT pg_catalog.pg_extension_config_dump('my_config', '');
SELECT pg_catalog.pg_extension_config_dump('my_config_seq', '');

锟斤拷锟斤拷锟斤拷锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷谋锟斤拷锟斤拷锟斤拷锟斤拷小锟斤拷锟�serial锟斤拷锟斤拷bigserial锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭诧拷锟斤拷员锟斤拷锟角★拷

锟斤拷pg_extension_config_dump锟侥第讹拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟街凤拷锟斤拷时锟斤拷锟矫憋拷锟斤拷全锟斤拷锟斤拷锟捷讹拷锟结被pg_dump转锟斤拷锟斤拷锟斤拷通锟斤拷只锟斤拷锟节憋拷锟斤拷锟斤拷展锟脚憋拷锟斤拷锟斤拷为锟斤拷始为锟斤拷时锟斤拷锟斤拷确锟斤拷锟斤拷锟斤拷诒锟斤拷谢锟斤拷锟叫筹拷始锟斤拷锟捷猴拷锟矫伙拷锟结供锟斤拷锟斤拷锟捷ｏ拷pg_extension_config_dump锟侥第讹拷锟斤拷锟斤拷锟斤拷锟结供锟斤拷一锟斤拷WHERE锟斤拷锟斤拷锟斤拷选锟斤拷要锟斤拷转锟斤拷锟斤拷锟斤拷锟捷★拷锟斤拷锟界，锟斤拷锟斤拷芑锟斤拷锟� 

CREATE TABLE my_config (key text, value text, standard_entry boolean);

SELECT pg_catalog.pg_extension_config_dump('my_config', 'WHERE NOT standard_entry');

锟斤拷锟斤拷确锟斤拷只锟斤拷锟斤拷展锟脚憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷standard_entry锟斤拷为锟芥。

锟斤拷锟斤拷锟斤拷锟叫ｏ拷锟节讹拷锟斤拷锟斤拷锟斤拷pg_extension_config_dump没锟斤拷影锟届。

锟斤拷锟斤拷锟接碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷没锟斤拷锟斤拷芑锟斤拷薷某锟绞硷拷峁╋拷锟斤拷锟斤拷荩锟斤拷锟斤拷锟酵拷锟斤拷锟斤拷锟斤拷帽锟斤拷洗锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街わ拷锟斤拷薷牡锟斤拷谢岜伙拷锟饺凤拷乇锟角★拷

锟斤拷锟酵拷锟斤拷俅蔚锟斤拷锟�pg_extension_config_dump锟斤拷锟睫革拷锟斤拷一锟斤拷锟斤拷锟矫憋拷锟斤拷氐墓锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟秸癸拷锟斤拷陆疟锟斤拷锟斤拷茫锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷为锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟矫憋拷锟侥凤拷锟斤拷锟斤拷锟斤拷ALTER EXTENSION ... DROP TABLE锟斤拷锟斤拷锟斤拷锟斤拷展锟斤拷锟诫开锟斤拷

注锟斤拷锟斤拷些锟斤拷之锟斤拷锟斤拷锟斤拷锟斤拷系锟斤拷锟斤拷指锟斤拷锟斤拷些锟斤拷锟斤拷 pg_dump 转锟斤拷锟斤拷顺锟斤拷锟截憋拷兀锟絧g_dump 锟斤拷锟斤拷锟斤拷 锟斤拷转锟斤拷锟斤拷锟斤拷锟矫的憋拷锟斤拷转锟斤拷锟斤拷锟矫憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟较碉拷锟斤拷锟� CREATE EXTENSION 时锟戒（锟斤拷锟斤拷锟斤拷锟捷憋拷锟斤拷锟斤拷 锟斤拷锟斤拷锟叫ｏ拷锟斤拷锟斤拷锟侥ｏ拷锟斤拷状锟斤拷锟斤拷锟斤拷没锟叫斤拷锟斤拷锟斤拷锟斤拷锟斤拷状锟斤拷锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷锟捷斤拷锟斤拷然锟斤拷转锟斤拷锟斤拷锟斤拷锟角革拷转锟斤拷锟睫凤拷锟斤拷 直锟接恢革拷锟斤拷锟揭憋拷锟斤拷要锟矫伙拷锟侥斤拷锟诫。

锟斤拷serial锟斤拷锟斤拷bigserial锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭拷锟街憋拷颖锟斤拷锟斤拷转锟斤拷锟斤拷锟角碉拷状态锟斤拷只锟斤拷锟斤拷锟斤拷堑母锟斤拷锟较碉拷锟斤拷锟斤拷锟阶拷锟斤拷锟斤拷堑锟阶刺拷锟�

36.15.4. 锟斤拷展锟斤拷锟斤拷

锟斤拷展锟斤拷锟狡碉拷一锟斤拷锟脚碉拷锟斤拷锟斤拷锟结供锟剿凤拷锟斤拷姆锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫╋拷锟斤拷锟斤拷锟秸癸拷卸锟斤拷锟斤拷 SQL 锟斤拷锟斤拷母锟斤拷隆锟斤拷锟斤拷锟酵拷锟轿拷锟秸癸拷陌锟阶帮拷疟锟斤拷锟矫恳伙拷锟斤拷锟斤拷邪姹撅拷锟斤拷锟揭伙拷锟斤拷姹撅拷锟斤拷苹锟斤拷甙姹撅拷锟绞碉拷值摹锟斤拷锟斤拷猓拷锟斤拷锟斤拷希锟斤拷锟矫伙拷锟杰癸拷锟斤拷态锟截帮拷锟斤拷锟角碉拷锟斤拷锟捷匡拷锟揭伙拷锟斤拷姹撅拷锟斤拷碌锟斤拷锟揭伙拷锟斤拷姹撅拷锟斤拷锟接︼拷锟斤拷峁�锟斤拷锟铰脚憋拷锟斤拷锟斤拷锟斤拷要锟侥革拷锟侥★拷锟斤拷锟铰脚憋拷锟斤拷锟斤拷锟斤拷锟斤拷循extension--oldversion--newversion.sql模式锟斤拷锟斤拷锟界，foo--1.0--1.1.sql锟斤拷锟斤拷锟脚帮拷锟斤拷展foo锟侥版本1.0锟睫改成版本1.1锟斤拷锟斤拷锟筋）锟斤拷

锟劫讹拷锟斤拷一锟斤拷锟斤拷锟绞的革拷锟铰脚憋拷锟斤拷锟矫ｏ拷锟斤拷锟斤拷ALTER EXTENSION UPDATE锟斤拷锟斤拷一锟斤拷锟窖帮拷装锟斤拷锟斤拷展锟斤拷锟铰碉拷指锟斤拷锟斤拷锟铰版本锟斤拷锟斤拷锟铰脚憋拷锟斤拷锟斤拷锟斤拷锟斤拷CREATE EXTENSION锟结供锟斤拷锟斤拷装锟脚憋拷锟斤拷同锟侥伙拷锟斤拷锟叫ｏ拷锟截憋拷锟斤拷search_path锟结按锟斤拷锟斤拷同锟侥凤拷式锟斤拷锟矫ｏ拷锟斤拷锟揭该脚憋拷锟斤拷锟斤拷锟斤拷锟轿猴拷锟铰讹拷锟斤拷岜伙拷远锟斤拷丶锟斤拷氲斤拷锟秸癸拷小锟�

锟斤拷锟揭伙拷锟斤拷锟秸癸拷锟斤拷卸锟斤拷锟斤拷锟斤拷锟斤拷募锟斤拷锟斤拷锟斤拷诟锟斤拷陆疟锟斤拷目锟斤拷撇锟斤拷锟斤拷锟斤拷锟叫╋拷锟斤拷锟侥匡拷锟芥本锟斤拷氐牟锟斤拷锟斤拷锟�

锟斤拷锟铰伙拷锟狡匡拷锟皆憋拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟揭拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷"锟斤拷散锟斤拷"锟斤拷锟襟集猴拷转锟斤拷锟揭伙拷锟斤拷锟秸癸拷锟斤拷锟斤拷锟秸癸拷锟斤拷票锟斤拷锟斤拷氲�PostgreSQL锟斤拷锟斤拷 9.1 锟斤拷始锟斤拷之前锟斤拷锟杰讹拷锟剿憋拷写锟斤拷锟斤拷展模锟斤拷虻サ卮锟斤拷锟斤拷锟斤拷指锟斤拷锟轿达拷锟斤拷锟侥讹拷锟襟。革拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷库，锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟杰斤拷锟斤拷些锟斤拷锟斤拷转锟斤拷锟揭伙拷锟斤拷锟饺凤拷锟斤拷锟斤拷锟斤拷展锟斤拷锟斤拷锟斤拷锟斤拷全锟斤拷删锟斤拷然锟斤拷锟斤拷一锟斤拷CREATE EXTENSION锟斤拷一锟街凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷纾拷锟斤拷锟斤拷一些锟斤拷锟斤拷使锟斤拷锟斤拷锟斤拷展锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵ｏ拷锟斤拷锟斤拷胁锟酵拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟侥凤拷锟斤拷锟角达拷锟斤拷一锟斤拷锟斤拷锟斤拷展锟斤拷然锟斤拷使锟斤拷ALTER EXTENSION ADD锟斤拷每一锟斤拷锟斤拷前锟酵达拷锟节的讹拷锟斤拷锟脚碉拷锟斤拷锟斤拷展锟斤拷锟斤拷蟠唇锟斤拷诘锟角帮拷锟秸癸拷姹撅拷卸锟斤拷锟斤拷锟轿达拷锟斤拷锟芥本锟叫碉拷锟轿猴拷锟铰讹拷锟斤拷CREATE EXTENSION锟斤拷锟斤拷锟斤拷FROM old_version选锟斤拷支锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟结导锟斤拷锟斤拷锟斤拷为目锟斤拷姹撅拷锟斤拷锟斤拷锟斤拷锟斤拷陌锟阶帮拷疟锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿�extension--old_version--target_version.sql锟侥革拷锟铰脚憋拷锟斤拷选锟斤拷锟斤拷为old_version使锟矫碉拷锟斤拷侔姹撅拷锟斤拷锟斤拷锟斤拷锟秸癸拷锟斤拷叩墓锟斤拷锟斤拷锟斤拷锟斤拷锟�unpackaged锟斤拷一锟斤拷习锟斤拷锟矫凤拷锟斤拷锟斤拷锟斤拷锟斤拷卸锟斤拷锟斤拷锟节版本锟斤拷要锟斤拷锟铰碉拷锟斤拷展锟斤拷锟绞癸拷枚锟斤拷锟斤拷侔姹撅拷锟斤拷锟斤拷锟斤拷锟绞讹拷锟斤拷恰锟�

ALTER EXTENSION锟杰癸拷执锟叫革拷锟铰脚憋拷锟斤拷锟斤拷锟斤拷锟斤拷实锟斤拷一锟斤拷要锟斤拷母锟斤拷隆锟斤拷锟斤拷纾拷锟斤拷只锟斤拷foo--1.0--1.1.sql锟斤拷foo--1.1--2.0.sql锟斤拷锟矫ｏ拷锟斤拷前锟斤拷装锟斤拷1.0锟芥本锟斤拷锟斤拷要锟斤拷锟斤拷碌锟斤拷姹�2.0锟斤拷ALTER EXTENSION锟斤拷锟斤拷锟斤拷应锟斤拷锟斤拷锟角★拷

PostgreSQL锟斤拷锟斤拷锟劫讹拷锟轿猴拷锟叫关版本锟斤拷锟狡碉拷锟斤拷锟绞ｏ拷锟斤拷锟界，锟斤拷锟斤拷知锟斤拷1.1锟角凤拷锟斤拷锟�1.0锟斤拷锟芥。锟斤拷只锟斤拷匹锟斤拷锟斤拷玫陌姹撅拷锟斤拷撇锟斤拷锟斤拷锟斤拷锟揭拷锟接︼拷锟斤拷锟斤拷俑锟斤拷陆疟锟斤拷锟铰凤拷锟斤拷锟斤拷校锟揭伙拷锟斤拷姹撅拷锟斤拷锟绞碉拷锟斤拷峡锟斤拷锟斤拷遣锟斤拷锟�--锟斤拷锟斤拷前锟斤拷锟斤拷锟阶�-锟斤拷锟街凤拷锟斤拷锟斤拷锟斤拷

锟斤拷时锟结供"锟斤拷锟斤拷"锟脚憋拷也锟斤拷锟矫ｏ拷锟斤拷锟斤拷foo--1.1--1.0.sql锟斤拷锟斤拷锟窖版本1.1锟斤拷氐母谋锟街革拷原状锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭拷锟斤拷慕锟斤拷锟斤拷疟锟斤拷锟斤拷锟斤拷锟接︼拷玫目锟斤拷锟斤拷裕锟斤拷锟轿拷锟斤拷锟矫碉拷一锟斤拷锟较短碉拷路锟斤拷锟斤拷危锟秸碉拷锟斤拷锟斤拷牵锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷姹撅拷锟�"锟斤拷锟斤拷路锟斤拷"锟斤拷锟铰脚憋拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟矫匡拷锟斤拷路锟斤拷锟斤拷始锟斤拷慕锟斤拷锟斤拷疟锟斤拷锟斤拷锟接︼拷媒锟斤拷锟饺伙拷锟斤拷锟接︼拷每锟斤拷锟铰凤拷锟斤拷锟斤拷鼙锟揭伙拷锟斤拷锟斤拷锟揭伙拷锟斤拷姹撅拷锟揭拷锟斤拷俚牟锟斤拷琛ｏ拷锟斤拷锟斤拷锟斤拷锟芥本删锟斤拷锟斤拷锟轿何诧拷锟斤拷锟斤拷锟斤拷亩锟斤拷锟斤拷饨拷锟矫碉拷锟斤拷锟诫不锟斤拷锟侥斤拷锟斤拷锟�

要锟斤拷锟斤拷锟斤拷锟街拷锟侥革拷锟斤拷路锟斤拷锟斤拷锟斤拷使锟斤拷锟斤拷锟斤拷锟斤拷睿� 

SELECT * FROM pg_extension_update_paths('extension_name');

锟斤拷锟轿革拷锟斤拷锟斤拷锟秸癸拷锟绞撅拷锟街拷锟矫恳伙拷锟斤拷锟斤拷锟斤拷值陌姹撅拷锟斤拷裕锟矫恳伙拷锟斤拷姹撅拷锟斤拷曰锟斤拷锟斤拷锟揭伙拷锟斤拷锟皆达拷姹撅拷锟侥匡拷锟芥本锟侥革拷锟斤拷路锟斤拷锟斤拷锟叫ｏ拷锟斤拷锟矫伙拷锌锟斤拷玫母锟斤拷锟铰凤拷锟斤拷锟斤拷獠匡拷锟斤拷锟较⑽�NULL锟斤拷锟斤拷路锟斤拷锟斤拷示为锟斤拷--锟街革拷锟斤拷锟斤拷锟侥憋拷锟斤拷式锟斤拷锟斤拷锟斤拷锟斤拷喜锟斤拷锟斤拷锟斤拷锟绞斤拷锟斤拷锟斤拷锟绞癸拷锟�regexp_split_to_array(path,'--')锟斤拷

36.15.5. 锟斤拷展实锟斤拷

锟斤拷锟斤拷锟斤拷一锟斤拷只锟斤拷SQL锟斤拷锟斤拷展锟斤拷锟斤拷锟斤拷锟斤拷锟接ｏ拷一锟斤拷锟斤拷锟斤拷元锟截碉拷锟斤拷锟斤拷锟斤拷停锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷牟郏锟斤拷锟斤拷锟轿�"k"锟斤拷"v"锟斤拷锟叫存储锟轿猴拷锟斤拷锟酵碉拷值锟斤拷锟斤拷锟侥憋拷值锟结被锟皆讹拷强锟斤拷为锟侥憋拷锟斤拷锟叫存储锟斤拷

锟脚憋拷锟侥硷拷pair--1.0.sql锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 

-- 锟斤拷锟斤拷疟锟斤拷锟斤拷锟� psql 锟斤拷锟斤拷锟斤拷 CREATE EXTENSION 执锟叫ｏ拷锟津报达拷
\echo Use "CREATE EXTENSION pair" to load this file. \quit

CREATE TYPE pair AS ( k text, v text );

CREATE OR REPLACE FUNCTION pair(anyelement, text)
RETURNS pair LANGUAGE SQL AS 'SELECT ROW($1, $2)::pair';

CREATE OR REPLACE FUNCTION pair(text, anyelement)
RETURNS pair LANGUAGE SQL AS 'SELECT ROW($1, $2)::pair';

CREATE OR REPLACE FUNCTION pair(anyelement, anyelement)
RETURNS pair LANGUAGE SQL AS 'SELECT ROW($1, $2)::pair';

CREATE OR REPLACE FUNCTION pair(text, text)
RETURNS pair LANGUAGE SQL AS 'SELECT ROW($1, $2)::pair;';

CREATE OPERATOR ~> (LEFTARG = text, RIGHTARG = anyelement, PROCEDURE = pair);
CREATE OPERATOR ~> (LEFTARG = anyelement, RIGHTARG = text, PROCEDURE = pair);
CREATE OPERATOR ~> (LEFTARG = anyelement, RIGHTARG = anyelement, PROCEDURE = pair);
CREATE OPERATOR ~> (LEFTARG = text, RIGHTARG = text, PROCEDURE = pair);

锟斤拷锟斤拷锟侥硷拷pair.control锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 

# pair 锟斤拷展
comment = 'A key/value pair data type'
default_version = '1.0'
relocatable = true

锟斤拷然锟姐几锟斤拷锟斤拷锟斤拷锟斤拷要一锟斤拷 makefile 锟斤拷锟斤拷装锟斤拷锟斤拷锟斤拷锟侥硷拷锟斤拷锟斤拷确锟斤拷目录锟斤拷锟姐还锟角匡拷锟斤拷使锟斤拷一锟斤拷Makefile锟斤拷 

EXTENSION = pair
DATA = pair--1.0.sql

PG_CONFIG = pg_config
PGXS := $(shell $(PG_CONFIG) --pgxs)
include $(PGXS)

锟斤拷锟� makefile 锟斤拷锟斤拷锟斤拷PGXS锟斤拷锟斤拷锟斤拷锟斤拷 36.16 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷make install锟斤拷锟窖匡拷锟狡和脚憋拷锟侥硷拷锟斤拷装锟斤拷pg_config锟斤拷锟斤拷锟斤拷锟饺凤拷锟侥柯硷拷小锟�

一锟斤拷锟侥硷拷锟斤拷锟斤拷装锟斤拷使锟斤拷CREATE EXTENSION锟斤拷锟斤拷涂锟斤拷园讯锟斤拷锟斤拷锟斤拷氲斤拷魏锟斤拷囟锟斤拷锟斤拷锟斤拷菘锟斤拷小锟�

锟斤拷一页锟斤拷始页锟斤拷一页
锟斤拷锟斤拷锟侥接匡拷锟斤拷展锟斤拷一锟斤拷锟斤拷展锟侥癸拷锟斤拷锟斤拷锟斤拷锟斤拷施