Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitcbf7ed5

Browse files
committed
doc: Improve CREATE PUBLICATION examples
1 parentb941891 commitcbf7ed5

File tree

1 file changed

+14
-5
lines changed

1 file changed

+14
-5
lines changed

‎doc/src/sgml/ref/create_publication.sgml

Lines changed: 14 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -163,7 +163,7 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
163163
</para>
164164

165165
<para>
166-
<command>TRUNCATE</command> andother<acronym>DDL</acronym> operations
166+
<command>TRUNCATE</command> and <acronym>DDL</acronym> operations
167167
are not published.
168168
</para>
169169
</refsect1>
@@ -172,16 +172,25 @@ CREATE PUBLICATION <replaceable class="parameter">name</replaceable>
172172
<title>Examples</title>
173173

174174
<para>
175-
Create asimplepublication thatjustpublishes allDML for tablesinit:
175+
Create a publication that publishes allchangesintwo tables:
176176
<programlisting>
177-
CREATE PUBLICATION mypublication;
177+
CREATE PUBLICATION mypublication FOR TABLE users, departments;
178178
</programlisting>
179179
</para>
180180

181181
<para>
182-
Createan insert-onlypublication:
182+
Createapublication that publishes all changes in all tables:
183183
<programlisting>
184-
CREATE PUBLICATION insert_only WITH (NOPUBLISH UPDATE, NOPUBLISH DELETE);
184+
CREATE PUBLICATION alltables FOR ALL TABLES;
185+
</programlisting>
186+
</para>
187+
188+
<para>
189+
Create a publication that only publishes <command>INSERT</command>
190+
operations in one table:
191+
<programlisting>
192+
CREATE PUBLICATION insert_only FOR TABLE mydata
193+
WITH (NOPUBLISH UPDATE, NOPUBLISH DELETE);
185194
</programlisting>
186195
</para>
187196
</refsect1>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp