logo
Free, Micro AI Code Reviews That Run on Git Commit
git-lrc git-lrc GitHub Install Now We'd appreciate a star git-lrc - Free, Micro AI Code Reviews That Run on Git Commit | Product Hunt git-lrc - Free, Micro AI Code Reviews That Run on Git 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