From cbf7ed51b8c0c3e506b91765769f76d5c2e1e9ac Mon Sep 17 00:00:00 2001 From: Peter Eisentraut Date: Wed, 22 Mar 2017 15:26:59 -0400 Subject: [PATCH] doc: Improve CREATE PUBLICATION examples --- doc/src/sgml/ref/create_publication.sgml | 19 ++++++++++++++----- 1 file changed, 14 insertions(+), 5 deletions(-) diff --git a/doc/src/sgml/ref/create_publication.sgml b/doc/src/sgml/ref/create_publication.sgml index b00a91ef8a..3cdde801fa 100644 --- a/doc/src/sgml/ref/create_publication.sgml +++ b/doc/src/sgml/ref/create_publication.sgml @@ -163,7 +163,7 @@ CREATE PUBLICATION name - TRUNCATE and other DDL operations + TRUNCATE and DDL operations are not published. @@ -172,16 +172,25 @@ CREATE PUBLICATION name Examples - Create a simple publication that just publishes all DML for tables in it: + Create a publication that publishes all changes in two tables: -CREATE PUBLICATION mypublication; +CREATE PUBLICATION mypublication FOR TABLE users, departments; - Create an insert-only publication: + Create a publication that publishes all changes in all tables: -CREATE PUBLICATION insert_only WITH (NOPUBLISH UPDATE, NOPUBLISH DELETE); +CREATE PUBLICATION alltables FOR ALL TABLES; + + + + + Create a publication that only publishes INSERT + operations in one table: + +CREATE PUBLICATION insert_only FOR TABLE mydata + WITH (NOPUBLISH UPDATE, NOPUBLISH DELETE); -- 2.40.0