SQL COMMANDS / LOGICAL REPLICATION
DROP PUBLICATION
Read PG 18 manual ↗remove a publication
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.
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 PUBLICATIONRelated entries
Definition snapshot: 2026-09-14T13:14:25.700916+00:00@99e6866c · English manual source