Help Center/ GaussDB(DWS)/ SQL Syntax Reference/ SQL Syntax Reference (9.1.0.x)/ DDL Syntax/ ALTER PUBLICATION
Updated on 2025-07-22 GMT+08:00
View PDF
Share

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

Table 1 ALTER PUBLICATION parameters

Parameter

Description

Value Range

name

Specifies the publication name to be modified.

-

table_name

Specifies the table name.

Name of an existing table.

schema_name

Specifies the schema name.

Name of an existing schema.

SET ( publication_parameter [= value] [, ... ] )

Modifies the publication parameters initially set by CREATE PUBLICATION.

For details about the parameters, see the Parameter Description in CREATE PUBLICATION.

new_owner

Specifies the new owner of the publication.

Name of an existing user.

new_name

Specifies the new name of the publication.

A string compliant with the identifier naming rules.

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

Parent Topic: DDL Syntax