ALTER SUBSCRIPTION

Syntax

ALTER SUBSCRIPTION subscription_name
    alter_option;

alter_option depends on the operation you want to perform on the subscription. For all supported clauses, see the sections below.

ALTER SUBSCRIPTION current_subscription_name
    OWNER TO new_user;

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.

-- Change the owner of the subscription named "sub" to user "admin"
ALTER SUBSCRIPTION sub OWNER TO admin;

ALTER SUBSCRIPTION subscription_name
    RENAME TO new_name;

Parameter or clause	Description
RENAME TO	This clause changes the name of the subscription.
new_name	The new name of the subscription.

-- Rename the subscription named "sub0" to "sub1"
ALTER SUBSCRIPTION sub0 RENAME TO sub1;

ALTER SUBSCRIPTION subscription_name
    SET RETENTION { TO | = } '<duration>';

Parameter or clause	Description
SET RETENTION	Changes how long incremental subscription data is retained.
duration	An interval such as `3H` or `2D`.

-- Retain incremental data for two days.
ALTER SUBSCRIPTION user_updates SET RETENTION TO '2D';

Increasing the retention period preserves incremental data for longer. Data that has already expired cannot be restored by increasing retention.

ALTER SUBSCRIPTION current_subscription_name
    SET SCHEMA schema_name;

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.

-- Move the subscription named "test_subscription" to the schema named "test_schema"
ALTER SUBSCRIPTION test_subscription SET SCHEMA test_schema;

ALTER SUBSCRIPTION name
SWAP WITH target_name;

Parameter	Description
name	The current name of the subscription to swap.
target_name	The target name of the subscription you want to swap with.

-- Swap the names of the user_updates subscription and the admin_updates subscription.
ALTER SUBSCRIPTION user_updates
SWAP WITH admin_updates;