Browse categories
Random entry
Blog
PostgreSQL releases
- PostgreSQL 16 (dev)
- PostgreSQL 15 (latest)
- PostgreSQL 14
- PostgreSQL 13
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Contrib modules
Object Identifier Types
Progress reporting views
Storage parameters (relopts)
Predefined roles

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL
Abbreviations and acronyms

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

ALTER SUBSCRIPTION

An SQL command for modifying a subscription

ALTER SUBSCRIPTION is a DDL command for modifying a subscription.

ALTER SUBSCRIPTION was added in PostgreSQL 10.

Change history

PostgreSQL 15
- ALTER SUBSCRIPTION ... SKIP syntax added (commit 208c5d65)
- parameter disable_on_error added (commit 705e20f8)
- a WARNING will now be emitted if the target publication does not exist on ALTER SUBSCRIPTION ... SET PUBLICATION ... (commit 8f2e2bbf)
PostgreSQL 14
- ALTER SUBSCRIPTION ... [ ADD | DROP ] PUBLICATION syntax added (commit 82ed7748)
- parameter binary added (commit 9de77b54)
- parameter streaming added (commit 46482432)
- ALTER SUBSCRIPTION ... OWNER TO CURRENT_ROLE syntax added (commit 45b98057)
PostgreSQL 10
- added (commit 665d1fad)

References

PostgreSQL documentation: ALTER SUBSCRIPTION

Categories

See also

CREATE SUBSCRIPTION, DROP SUBSCRIPTION