CREATE PUBLICATION mydbpub FOR ALL TABLES; Note that when you say FOR ALL TABLES, you're indicating that you want to publish not only all of the tables that currently exist in this database, but also ...