DROP PUBLICATION

An SQL command for removing a publication

DROP PUBLICATION is a DDL command for removing a publication.

DROP PUBLICATION was added in PostgreSQL 10.

Change history

Examples

Example usage for DROP PUBLICATION:

postgres=# DROP PUBLICATION misc_publication;
DROP PUBLICATION

Attempting to drop a non-existent publication:

postgres=# DROP PUBLICATION foo;
ERROR:  publication "foo" does not exist

Categories

DDL, Logical replication, SQL command

See also

ALTER PUBLICATION, CREATE PUBLICATION, pg_publication, pg_publication_rel