ALTER PUBLICATION ALTER PUBLICATION 7 SQL - Language Statements ALTER PUBLICATION change the definition of a publication ALTER PUBLICATION name WITH ( option [, ... ] ) where option can be: PUBLISH INSERT | NOPUBLISH INSERT | PUBLISH UPDATE | NOPUBLISH UPDATE | PUBLISH DELETE | NOPUBLISH DELETE ALTER PUBLICATION name OWNER TO { new_owner | CURRENT_USER | SESSION_USER } ALTER PUBLICATION name ADD TABLE table_name [, ...] ALTER PUBLICATION name SET TABLE table_name [, ...] ALTER PUBLICATION name DROP TABLE table_name [, ...] The first variant of this command listed in the synopsis can change all of the publication properties specified in . Properties not mentioned in the command retain their previous settings. Database superusers can change any of these settings for any role. To alter the owner, you must also be a direct or indirect member of the new owning role. The new owner has to be a superuser The other variants of this command deal with the table membership of the publication. The SET TABLE clause will replace the list of tables in the publication with the specified one. The ADD TABLE and DROP TABLE will add and remove one or more tables from the publication. name The name of an existing publication whose definition is to be altered. PUBLISH INSERT NOPUBLISH INSERT PUBLISH UPDATE NOPUBLISH UPDATE PUBLISH DELETE NOPUBLISH DELETE These clauses alter properties originally set by . See there for more information. table_name Name of an existing table. Change the publication to not publish inserts: ALTER PUBLICATION noinsert WITH (NOPUBLISH INSERT); Add some tables to the publication: ALTER PUBLICATION mypublication ADD TABLE users, departments; ALTER PUBLICATION is a PostgreSQL extension.