Firstly, if you're not using 9.1+, please 100.
如何安装PostgreSQL 9.1的扩展?
Firstly, if you're not using 9.1+, please 100.
如何安装PostgreSQL 9.1的扩展?
PostgrSeql9.1提供了一个新的命令CREATE EXTENSION
.你应该用它来安装模块.
Modules provided in 9.1 can be found here..其中包括:,
adminpack , auth_delay , auto_explain , btree_gin , btree_gist
, chkpass , citext , cube , dblink , dict_int
, dict_xsyn , dummy_seclabel , earthdistance , file_fdw , fuzzystrmatch
, hstore , intagg , intarray , isn , lo
, ltree , oid2name , pageinspect , passwordcheck , pg_archivecleanup
, pgbench , pg_buffercache , pgcrypto , pg_freespacemap , pgrowlocks
, pg_standby , pg_stat_statements , pgstattuple , pg_test_fsync , pg_trgm
, pg_upgrade , seg , sepgsql , spi , sslinfo , tablefunc
, test_parser , tsearch2 , unaccent , uuid-ossp , vacuumlo
, xml2
例如,如果您想安装earthdistance
,只需使用以下命令:
CREATE EXTENSION earthdistance;
如果要安装名称中带有连字符(如uuid-ossp
)的扩展名,则需要将扩展名用双引号括起来:
CREATE EXTENSION "uuid-ossp";
DROP EXTENSION
.您还可以获得扩展列表,并且对版本号有基本的支持.