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