将PostgreSQL扩展安装到所有模式

CREATE EXTENSION unaccent;将扩展安装到公共模式中.为了实现它,只需在更改search_path时包括：

set search_path = my_schema,public;

或者更好地创建包含所有扩展的模式,然后始终将该模式附加到search_path.

create schema extensions;

-- make sure everybody can use everything in the extensions schema
grant usage on schema extensions to public;
grant execute on all functions in schema extensions to public;

-- include future extensions
alter default privileges in schema extensions
   grant execute on functions to public;

alter default privileges in schema extensions
   grant usage on types to public;

现在安装扩展程序：

create extension unaccent schema extensions;

然后在search_path中使用include该模式

set search_path = my_schema,extensions;

如果您不想为您创建的每个新数据库重复上述步骤,请在连接到template1数据库时运行上述步骤.您甚至可以通过编辑postgresql.conf或使用alter system在默认search_path中包含扩展架构