Home Explore Blog CI



postgresql

2nd chunk of `doc/src/sgml/contrib.sgml`
7cd747a2388b4704343c531e0d32c155c11b6543997a9e2a0000000100000970
 <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;
 &ltree;
 &pageinspect;
 &passwordcheck;

Title: Trusted Extensions and Installation Options
Summary
This section lists the trusted extensions in a default PostgreSQL installation, explains how to install extensions in a specific schema, and notes that some components are not extensions in the classical sense and are loaded into the server in other ways, with details provided in the documentation for each component.