1DROP PUBLICATION(7)      PostgreSQL 12.6 Documentation     DROP PUBLICATION(7)
2
3
4

NAME

6       DROP_PUBLICATION - remove a publication
7

SYNOPSIS

9       DROP PUBLICATION [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]
10

DESCRIPTION

12       DROP PUBLICATION removes an existing publication from the database.
13
14       A publication can only be dropped by its owner or a superuser.
15

PARAMETERS

17       IF EXISTS
18           Do not throw an error if the publication does not exist. A notice
19           is issued in this case.
20
21       name
22           The name of an existing publication.
23
24       CASCADE
25       RESTRICT
26           These key words do not have any effect, since there are no
27           dependencies on publications.
28

EXAMPLES

30       Drop a publication:
31
32           DROP PUBLICATION mypublication;
33

COMPATIBILITY

35       DROP PUBLICATION is a PostgreSQL extension.
36

SEE ALSO

38       CREATE PUBLICATION (CREATE_PUBLICATION(7)), ALTER PUBLICATION
39       (ALTER_PUBLICATION(7))
40
41
42
43PostgreSQL 12.6                      2021                  DROP PUBLICATION(7)