ALTER PUBLICATION

Function

ALTER PUBLICATION modifies the publication attributes.

Precautions

• This statement is supported by version 8.2.0.100 or later clusters.
• This statement can be used by the owner of a publication and the system administrator only.
• To alter the publication owner, you must also be a direct or indirect member of the new owning role, and that role must have CREATE privilege on the database.
• In a publication with FOR ALL TABLES, the new publication owner must be the system administrator.
• An administrator can change the owner relationship of any publication.

Syntax

• Add objects to a publication.

  1	ALTER PUBLICATION name ADD publication_object [, ...]

• Delete objects from a publication.

  1	ALTER PUBLICATION name DROP publication_object [, ...]

• Replace the current object with a specified object.

  1	ALTER PUBLICATION name SET publication_object [, ...]

• Set publication parameters. Retain the original values of the parameters that are not mentioned.

  1	ALTER PUBLICATION name SET ( publication_parameter [= value] [, ... ] )

• Change the publication owner.

  1	ALTER PUBLICATION name OWNER TO new_owner

• Rename the publication.

  1	ALTER PUBLICATION name RENAME TO new_name

The syntax of using publication_object is as follows:

TABLE table_name [, ...]
| ALL TABLES IN SCHEMA schema_name [, ... ]

Parameter Description

Examples

• Add a table to a publication.

  ALTER PUBLICATION mypublication ADD TABLE mydata2;

• Deletes a schema from a publication.

  ALTER PUBLICATION mypublication DROP ALL TABLES IN SCHEMA myschema1;

• Reset a publication object.

  ALTER PUBLICATION mypublication SET TABLE mydata2, ALL TABLES IN SCHEMA myschema2;

• Change the publication owner.

  ALTER PUBLICATION mypublication OWNER TO user1;

• Change the publication name.

  ALTER PUBLICATION mypublication RENAME TO mypublication1;

Helpful Links

CREATE PUBLICATION and DROP PUBLICATION