begriffs open source - ai-pg/blob - full-docs/src/sgml/html/sql-dropextension.html

   1 <?xml version="1.0" encoding="UTF-8" standalone="no"?>
   2 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><title>DROP EXTENSION</title><link rel="stylesheet" type="text/css" href="stylesheet.css" /><link rev="made" href="pgsql-docs@lists.postgresql.org" /><meta name="generator" content="DocBook XSL Stylesheets Vsnapshot" /><link rel="prev" href="sql-dropeventtrigger.html" title="DROP EVENT TRIGGER" /><link rel="next" href="sql-dropforeigndatawrapper.html" title="DROP FOREIGN DATA WRAPPER" /></head><body id="docContent" class="container-fluid col-10"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="5" align="center">DROP EXTENSION</th></tr><tr><td width="10%" align="left"><a accesskey="p" href="sql-dropeventtrigger.html" title="DROP EVENT TRIGGER">Prev</a> </td><td width="10%" align="left"><a accesskey="u" href="sql-commands.html" title="SQL Commands">Up</a></td><th width="60%" align="center">SQL Commands</th><td width="10%" align="right"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="10%" align="right"> <a accesskey="n" href="sql-dropforeigndatawrapper.html" title="DROP FOREIGN DATA WRAPPER">Next</a></td></tr></table><hr /></div><div class="refentry" id="SQL-DROPEXTENSION"><div class="titlepage"></div><a id="id-1.9.3.111.1" class="indexterm"></a><div class="refnamediv"><h2><span class="refentrytitle">DROP EXTENSION</span></h2><p>DROP EXTENSION — remove an extension</p></div><div class="refsynopsisdiv"><h2>Synopsis</h2><pre class="synopsis">
   3 DROP EXTENSION [ IF EXISTS ] <em class="replaceable"><code>name</code></em> [, ...] [ CASCADE | RESTRICT ]
   4 </pre></div><div class="refsect1" id="id-1.9.3.111.5"><h2>Description</h2><p>
   5    <code class="command">DROP EXTENSION</code> removes extensions from the database.
   6    Dropping an extension causes its member objects, and other explicitly
   7    dependent routines (see <a class="xref" href="sql-alterroutine.html" title="ALTER ROUTINE"><span class="refentrytitle">ALTER ROUTINE</span></a>,
   8    the <code class="literal">DEPENDS ON EXTENSION <em class="replaceable"><code>extension_name</code></em>
   9    </code> action), to be dropped as well.
  10   </p><p>
  11    You must own the extension to use <code class="command">DROP EXTENSION</code>.
  12   </p></div><div class="refsect1" id="id-1.9.3.111.6"><h2>Parameters</h2><div class="variablelist"><dl class="variablelist"><dt><span class="term"><code class="literal">IF EXISTS</code></span></dt><dd><p>
  13       Do not throw an error if the extension does not exist. A notice is issued
  14       in this case.
  15      </p></dd><dt><span class="term"><em class="replaceable"><code>name</code></em></span></dt><dd><p>
  16       The name of an installed extension.
  17      </p></dd><dt><span class="term"><code class="literal">CASCADE</code></span></dt><dd><p>
  18       Automatically drop objects that depend on the extension,
  19       and in turn all objects that depend on those objects
  20       (see <a class="xref" href="ddl-depend.html" title="5.15. Dependency Tracking">Section 5.15</a>).
  21      </p></dd><dt><span class="term"><code class="literal">RESTRICT</code></span></dt><dd><p>
  22       This option prevents the specified extensions from being dropped if
  23       other objects, besides these extensions, their members, and their
  24       explicitly dependent routines, depend on them. This is the default.
  25      </p></dd></dl></div></div><div class="refsect1" id="id-1.9.3.111.7"><h2>Examples</h2><p>
  26    To remove the extension <code class="literal">hstore</code> from the current
  27    database:
  28 </p><pre class="programlisting">
  29 DROP EXTENSION hstore;
  30 </pre><p>
  31    This command will fail if any of <code class="literal">hstore</code>'s objects
  32    are in use in the database, for example if any tables have columns
  33    of the <code class="type">hstore</code> type.  Add the <code class="literal">CASCADE</code> option to
  34    forcibly remove those dependent objects as well.
  35   </p></div><div class="refsect1" id="id-1.9.3.111.8"><h2>Compatibility</h2><p>
  36    <code class="command">DROP EXTENSION</code> is a <span class="productname">PostgreSQL</span>
  37    extension.
  38   </p></div><div class="refsect1" id="id-1.9.3.111.9"><h2>See Also</h2><span class="simplelist"><a class="xref" href="sql-createextension.html" title="CREATE EXTENSION"><span class="refentrytitle">CREATE EXTENSION</span></a>, <a class="xref" href="sql-alterextension.html" title="ALTER EXTENSION"><span class="refentrytitle">ALTER EXTENSION</span></a></span></div></div><div class="navfooter"><hr /><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="sql-dropeventtrigger.html" title="DROP EVENT TRIGGER">Prev</a> </td><td width="20%" align="center"><a accesskey="u" href="sql-commands.html" title="SQL Commands">Up</a></td><td width="40%" align="right"> <a accesskey="n" href="sql-dropforeigndatawrapper.html" title="DROP FOREIGN DATA WRAPPER">Next</a></td></tr><tr><td width="40%" align="left" valign="top">DROP EVENT TRIGGER </td><td width="20%" align="center"><a accesskey="h" href="index.html" title="PostgreSQL 18.0 Documentation">Home</a></td><td width="40%" align="right" valign="top"> DROP FOREIGN DATA WRAPPER</td></tr></table></div></body></html>