如何在PostgreSQL 9.1中导入模块或安装扩展？

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";

> Read more about contrib,and the modules available in 9.1。
> Read about the new extension infrastructure,and the SQL commands to manage it here现在可以更轻松地卸载模块，请参见DROP EXTENSION。您还可以获取扩展列表，并且有版本号的基本支持。