<quote>trusted</quote>. Trusted extensions can be run by any
user who has <literal>CREATE</literal> privilege on the current
database. Extensions that are trusted are identified as such in the
sections that follow. Generally, trusted extensions are ones that cannot
provide access to outside-the-database functionality.
</para>
<para id="contrib-trusted-extensions">
The following extensions are trusted in a default installation:
<simplelist type="vert" columns="4">
<member><xref linkend="btree-gin"/></member>
<member><xref linkend="btree-gist"/></member>
<member><xref linkend="citext"/></member>
<member><xref linkend="cube"/></member>
<member><xref linkend="dict-int"/></member>
<member><xref linkend="fuzzystrmatch"/></member>
<member><xref linkend="hstore"/></member>
<member><xref linkend="intarray"/></member>
<member><xref linkend="isn"/></member>
<member><xref linkend="lo"/></member>
<member><xref linkend="ltree"/></member>
<member><xref linkend="pgcrypto"/></member>
<member><xref linkend="pgtrgm"/></member>
<member><xref linkend="seg"/></member>
<member><xref linkend="tablefunc"/></member>
<member><xref linkend="tcn"/></member>
<member><xref linkend="tsm-system-rows"/></member>
<member><xref linkend="tsm-system-time"/></member>
<member><xref linkend="unaccent"/></member>
<member><xref linkend="uuid-ossp"/></member>
</simplelist>
</para>
<para>
Many extensions allow you to install their objects in a schema of your
choice. To do that, add <literal>SCHEMA
<replaceable>schema_name</replaceable></literal> to the <command>CREATE EXTENSION</command>
command. By default, the objects will be placed in your current creation
target schema, which in turn defaults to <literal>public</literal>.
</para>
<para>
Note, however, that some of these components are not <quote>extensions</quote>
in this sense, but are loaded into the server in some other way, for instance
by way of
<xref linkend="guc-shared-preload-libraries"/>. See the documentation of each
component for details.
</para>
&amcheck;
&auth-delay;
&auto-explain;
&basebackup-to-shell;
&basic-archive;
&bloom;
&btree-gin;
&btree-gist;
&citext;
&cube;
&dblink;
&dict-int;
&dict-xsyn;
&earthdistance;
&file-fdw;
&fuzzystrmatch;
&hstore;
&intagg;
&intarray;
&isn;
&lo;
<ree;
&pageinspect;
&passwordcheck;