Syntax
alter_option
depends on the operation you want to perform on the subscription. For all supported clauses, see the sections below.
Clauses
OWNER TO
Parameter or clause | Description |
---|---|
OWNER TO | This clause changes the owner of the subscription. |
new_user | The new owner you want to assign to the subscription. |
RENAME TO
Parameter or clause | Description |
---|---|
RENAME TO | This clause changes the name of the subscription. |
new_name | The new name of the subscription. |
SET SCHEMA
Parameter or clause | Description |
---|---|
SET SCHEMA | This clause moves the subscription to a different schema. |
schema_name | The name of the schema to which the subscription will be moved. |
SWAP WITH
Parameter | Description |
---|---|
name | The current name of the subscription to swap. |
target_name | The target name of the subscription you want to swap with. |