logo
Free, unlimited AI code reviews that run on commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt git-lrc - Free, unlimited AI code reviews that run on commit | Product Hunt

DROP_PUBLICATION - remove a publication

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 ]

See Also