1<!--
2doc/src/sgml/ref/drop_publication.sgml
3PostgreSQL documentation
4-->
5
6<refentry id="SQL-DROPPUBLICATION">
7 <indexterm zone="sql-droppublication">
8  <primary>DROP PUBLICATION</primary>
9 </indexterm>
10
11 <refmeta>
12  <refentrytitle>DROP PUBLICATION</refentrytitle>
13  <manvolnum>7</manvolnum>
14  <refmiscinfo>SQL - Language Statements</refmiscinfo>
15 </refmeta>
16
17 <refnamediv>
18  <refname>DROP PUBLICATION</refname>
19  <refpurpose>remove a publication</refpurpose>
20 </refnamediv>
21
22 <refsynopsisdiv>
23<synopsis>
24DROP PUBLICATION [ IF EXISTS ] <replaceable class="PARAMETER">name</replaceable> [, ...] [ CASCADE | RESTRICT ]
25</synopsis>
26 </refsynopsisdiv>
27
28 <refsect1>
29  <title>Description</title>
30
31  <para>
32   <command>DROP PUBLICATION</command> removes an existing publication from
33   the database.
34  </para>
35
36  <para>
37   A publication can only be dropped by its owner or a superuser.
38  </para>
39 </refsect1>
40
41 <refsect1>
42  <title>Parameters</title>
43
44  <variablelist>
45   <varlistentry>
46    <term><literal>IF EXISTS</literal></term>
47    <listitem>
48     <para>
49      Do not throw an error if the publication does not exist. A notice is
50      issued in this case.
51     </para>
52    </listitem>
53   </varlistentry>
54
55   <varlistentry>
56    <term><replaceable class="parameter">name</replaceable></term>
57    <listitem>
58     <para>
59      The name of an existing publication.
60     </para>
61    </listitem>
62   </varlistentry>
63
64   <varlistentry>
65    <term><literal>CASCADE</literal></term>
66    <term><literal>RESTRICT</literal></term>
67
68    <listitem>
69     <para>
70      These key words do not have any effect, since there are no dependencies
71      on publications.
72     </para>
73    </listitem>
74   </varlistentry>
75  </variablelist>
76 </refsect1>
77
78 <refsect1>
79  <title>Examples</title>
80
81  <para>
82   Drop a publication:
83<programlisting>
84DROP PUBLICATION mypublication;
85</programlisting></para>
86 </refsect1>
87
88 <refsect1>
89  <title>Compatibility</title>
90
91  <para>
92   <command>DROP PUBLICATION</command> is a <productname>PostgreSQL</>
93   extension.
94  </para>
95 </refsect1>
96
97 <refsect1>
98  <title>See Also</title>
99
100  <simplelist type="inline">
101   <member><xref linkend="sql-createpublication"></member>
102   <member><xref linkend="sql-alterpublication"></member>
103  </simplelist>
104 </refsect1>
105</refentry>
106