1
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
8
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
10
HREF="mailto:pgsql-docs@postgresql.org"><LINK
12
TITLE="PostgreSQL 9.1beta1 Documentation"
13
HREF="index.html"><LINK
16
HREF="sql-commands.html"><LINK
19
HREF="sql-dropdomain.html"><LINK
21
TITLE="DROP FOREIGN DATA WRAPPER"
22
HREF="sql-dropforeigndatawrapper.html"><LINK
25
HREF="stylesheet.css"><META
26
HTTP-EQUIV="Content-Type"
27
CONTENT="text/html; charset=ISO-8859-1"><META
29
CONTENT="2011-04-27T21:20:33"></HEAD
35
SUMMARY="Header navigation table"
47
>PostgreSQL 9.1beta1 Documentation</A
57
HREF="sql-dropdomain.html"
67
HREF="sql-dropdomain.html"
80
TITLE="DROP FOREIGN DATA WRAPPER"
81
HREF="sql-dropforeigndatawrapper.html"
89
TITLE="DROP FOREIGN DATA WRAPPER"
90
HREF="sql-dropforeigndatawrapper.html"
101
NAME="SQL-DROPEXTENSION"
111
>DROP EXTENSION -- remove an extension</DIV
113
CLASS="REFSYNOPSISDIV"
121
>DROP EXTENSION [ IF EXISTS ] <TT
126
> [, ...] [ CASCADE | RESTRICT ]</PRE
139
> removes extensions from the database.
140
Dropping an extension causes its component objects to be dropped as well.
143
> You must own the extension to use <TT
168
> Do not throw an error if the extension does not exist. A notice is issued
181
> The name of an installed extension.
191
> Automatically drop objects that depend on the extension.
201
> Refuse to drop the extension if any objects depend on it (other than
202
its own member objects and other extensions listed in the same
206
> command). This is the default.
220
> To remove the extension <TT
226
CLASS="PROGRAMLISTING"
227
>DROP EXTENSION hstore;</PRE
229
This command will fail if any of <TT
233
are in use in the database, for example if any tables have columns
241
forcibly remove those dependent objects as well.
270
HREF="sql-createextension.html"
273
HREF="sql-alterextension.html"
281
SUMMARY="Footer navigation table"
292
HREF="sql-dropdomain.html"
310
HREF="sql-dropforeigndatawrapper.html"
326
HREF="sql-commands.html"
334
>DROP FOREIGN DATA WRAPPER</TD
b'\\ No newline at end of file'