DROP PUBLICATION
remove a publication
English manual coverage begins with PostgreSQL 6.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- anchor
- SQL-DROPPUBLICATION
- file
- sql-droppublication.html
- lang
- en
- name
- DROP PUBLICATION
- purpose
- remove a publication
- purpose zh
- 移除一个发布
- sections same as
- Unknown
- slug
- 18
- synopsis html
- DROP PUBLICATION [ IF EXISTS ] <em class="replaceable"><code>name</code></em> [, ...] [ CASCADE | RESTRICT ]
- synopsis text
- DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
Syntax
DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]Syntax diagrams
Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.
Definition PG 18
DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
Description
DROP PUBLICATION removes an existing publication from the database.
A publication can only be dropped by its owner or a superuser.
Parameters
IF EXISTSDo not throw an error if the publication does not exist. A notice is issued in this case.
nameThe name of an existing publication.
CASCADERESTRICTThese key words do not have any effect, since there are no dependencies on publications.
Examples
Drop a publication:
DROP PUBLICATION mypublication;
Compatibility
DROP PUBLICATION is a PostgreSQL extension.
See Also
CREATE PUBLICATION, ALTER PUBLICATIONCompare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:88b05518db62102f85fe0738b0b751796c2fa8bc98a8a339b50df3e218ec38cd
Text language: en · wiki-repair-20261023:88b05518db62102f85fe0738b0b751796c2fa8bc98a8a339b50df3e218ec38cd