<refsynopsisdiv>

<synopsis>

ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> WITH ( <replaceable class="PARAMETER">suboption</replaceable> [, ... ] ) ]

ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> WITH ( <replaceable class="PARAMETER">suboption</replaceable> [, ... ] )

<phrase>where <replaceable class="PARAMETER">suboption</replaceable> can be:</phrase>

SLOT NAME = <replaceable class="PARAMETER">slot_name</replaceable>

| SYNCHRONOUS_COMMIT = <replaceable class="PARAMETER">synchronous_commit</replaceable>

ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> SET PUBLICATION <replaceable class="PARAMETER">publication_name</replaceable> [, ...] { REFRESH WITH ( <replaceable class="PARAMETER">puboption</replaceable> [, ... ] ) | NOREFRESH }

ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> REFRESH PUBLICATION WITH ( <replaceable class="PARAMETER">puboption</replaceable> [, ... ] )

ALTER SUBSCRIPTION <replaceable class="PARAMETER">name</replaceable> REFRESH PUBLICATION[WITH ( <replaceable class="PARAMETER">puboption</replaceable> [, ... ] ) ]

<phrase>where <replaceable class="PARAMETER">puboption</replaceable> can be:</phrase>

<para>

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

new owning role. The new owner has to be a superuser.

</para>

</refsect1>