ApsaraDB RDS for PostgreSQL - FOR ALL TABLES Clause Available to rds_superuser
Dec 18 2019
ApsaraDB RDS for PostgreSQLThe FOR ALL TABLES clause is released to help the rds_superuser user publish all tables simultaneously for an ApsaraDB RDS for PostgreSQL instance.
Content
Target customers: ApsaraDB RDS for PostgreSQL users who implement logical replication between tables across databases or instances by using logical subscription or Data Transmission Service (DTS). Features released: You can log on as the rds_superuser user and use the FOR ALL TABLES clause to include all tables in one publication: ``` CREATE PUBLICATION name [ FOR TABLE [ ONLY ] table_name [ * ] [, ...] | FOR ALL TABLES ] [ WITH ( publication_parameter [= value] [, ... ] ) ] ``` With this clause, you can subscribe to more than one table at a time.
