doc/src/sgml/ref/drop_publication.sgml

   1 <!--
   2 doc/src/sgml/ref/drop_publication.sgml
   3 PostgreSQL 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>
  24 DROP 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>
  84 DROP 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</productname>
  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>