DROP_PUBLICATION - remove a publication
Contents
Compatibility
DROPPUBLICATION is a PostgreSQL extension.
Description
DROPPUBLICATION removes an existing publication from the database.
A publication can only be dropped by its owner or a superuser.
Examples
Drop a publication:
DROP PUBLICATION mypublication;
Name
DROP_PUBLICATION - remove a publication
Parameters
IF EXISTS
Do not throw an error if the publication does not exist. A notice is issued in this case.
name
The name of an existing publication.
CASCADE
RESTRICT
These key words do not have any effect, since there are no dependencies on publications.
See Also
CREATE PUBLICATION (CREATE_PUBLICATION(7)), ALTER PUBLICATION (ALTER_PUBLICATION(7))
PostgreSQL 17.5 2025 DROPPUBLICATION(7)
Synopsis
DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
