summaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src/sgml/ref')
-rw-r--r--doc/src/sgml/ref/create_index.sgml4
-rw-r--r--doc/src/sgml/ref/explain.sgml4
-rw-r--r--doc/src/sgml/ref/pgarchivecleanup.sgml3
-rw-r--r--doc/src/sgml/ref/pgtestfsync.sgml2
-rw-r--r--doc/src/sgml/ref/psql-ref.sgml14
-rw-r--r--doc/src/sgml/ref/reindex.sgml4
-rw-r--r--doc/src/sgml/ref/rollback_to.sgml4
-rw-r--r--doc/src/sgml/ref/select.sgml2
-rw-r--r--doc/src/sgml/ref/set_role.sgml4
-rw-r--r--doc/src/sgml/ref/set_session_auth.sgml4
-rw-r--r--doc/src/sgml/ref/show.sgml2
11 files changed, 23 insertions, 24 deletions
diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml
index 91eaaabc90f..d3102a87d92 100644
--- a/doc/src/sgml/ref/create_index.sgml
+++ b/doc/src/sgml/ref/create_index.sgml
@@ -649,9 +649,9 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] <replaceable class=
<programlisting>
postgres=# \d tab
Table "public.tab"
- Column | Type | Collation | Nullable | Default
+ Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
- col | integer | | |
+ col | integer | | |
Indexes:
"idx" btree (col) INVALID
</programlisting>
diff --git a/doc/src/sgml/ref/explain.sgml b/doc/src/sgml/ref/explain.sgml
index 857c4e6e867..d4895b9d7d4 100644
--- a/doc/src/sgml/ref/explain.sgml
+++ b/doc/src/sgml/ref/explain.sgml
@@ -395,7 +395,7 @@ EXPLAIN (FORMAT YAML) SELECT * FROM foo WHERE i='4';
Total Cost: 5.98 +
Plan Rows: 1 +
Plan Width: 4 +
- Index Cond: "(i = 4)"
+ Index Cond: "(i = 4)"
(1 row)
</programlisting>
@@ -442,7 +442,7 @@ PREPARE query(int, int) AS SELECT sum(bar) FROM test
EXPLAIN ANALYZE EXECUTE query(100, 200);
- QUERY PLAN
+ QUERY PLAN
-------------------------------------------------------------------&zwsp;-----------------------------------------------------
HashAggregate (cost=9.54..9.54 rows=1 width=8) (actual time=0.156..0.161 rows=11 loops=1)
Group Key: foo
diff --git a/doc/src/sgml/ref/pgarchivecleanup.sgml b/doc/src/sgml/ref/pgarchivecleanup.sgml
index e27db3c0773..635e7c76854 100644
--- a/doc/src/sgml/ref/pgarchivecleanup.sgml
+++ b/doc/src/sgml/ref/pgarchivecleanup.sgml
@@ -160,8 +160,7 @@ pg_archivecleanup: removing file "archive/00000001000000370000000E"
<literal>never</literal>.
</para>
</refsect1>
-
-
+
<refsect1>
<title>Notes</title>
diff --git a/doc/src/sgml/ref/pgtestfsync.sgml b/doc/src/sgml/ref/pgtestfsync.sgml
index 95be7a16d24..e811f80bf40 100644
--- a/doc/src/sgml/ref/pgtestfsync.sgml
+++ b/doc/src/sgml/ref/pgtestfsync.sgml
@@ -116,7 +116,7 @@ PostgreSQL documentation
<literal>never</literal>.
</para>
</refsect1>
-
+
<refsect1>
<title>See Also</title>
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml
index 592356019b5..8fc78707332 100644
--- a/doc/src/sgml/ref/psql-ref.sgml
+++ b/doc/src/sgml/ref/psql-ref.sgml
@@ -4992,7 +4992,7 @@ testdb=&gt; <userinput>\d my_table</userinput>
Column | Type | Collation | Nullable | Default
--------+---------+-----------+----------+---------
first | integer | | not null | 0
- second | text | | |
+ second | text | | |
</programlisting>
Now we change the prompt to something more interesting:
<programlisting>
@@ -5123,7 +5123,7 @@ testdb=&gt; <userinput>\df int*pl * bigint</userinput>
with the <command>\crosstabview</command> command:
<programlisting>
testdb=&gt; <userinput>SELECT first, second, first &gt; 2 AS gt2 FROM my_table;</userinput>
- first | second | gt2
+ first | second | gt2
-------+--------+-----
1 | one | f
2 | two | f
@@ -5132,11 +5132,11 @@ testdb=&gt; <userinput>SELECT first, second, first &gt; 2 AS gt2 FROM my_table;<
(4 rows)
testdb=&gt; <userinput>\crosstabview first second</userinput>
- first | one | two | three | four
+ first | one | two | three | four
-------+-----+-----+-------+------
- 1 | f | | |
- 2 | | f | |
- 3 | | | t |
+ 1 | f | | |
+ 2 | | f | |
+ 3 | | | t |
4 | | | | t
(4 rows)
</programlisting>
@@ -5148,7 +5148,7 @@ testdb=&gt; <userinput>SELECT t1.first as "A", t2.first+100 AS "B", t1.first*(t2
testdb(&gt; <userinput>row_number() over(order by t2.first) AS ord</userinput>
testdb(&gt; <userinput>FROM my_table t1 CROSS JOIN my_table t2 ORDER BY 1 DESC</userinput>
testdb(&gt; <userinput>\crosstabview "A" "B" "AxB" ord</userinput>
- A | 101 | 102 | 103 | 104
+ A | 101 | 102 | 103 | 104
---+-----+-----+-----+-----
4 | 404 | 408 | 412 | 416
3 | 303 | 306 | 309 | 312
diff --git a/doc/src/sgml/ref/reindex.sgml b/doc/src/sgml/ref/reindex.sgml
index 6a0eca8b9ac..36cb4a455b7 100644
--- a/doc/src/sgml/ref/reindex.sgml
+++ b/doc/src/sgml/ref/reindex.sgml
@@ -309,7 +309,7 @@ REINDEX [ ( <replaceable class="parameter">option</replaceable> [, ...] ) ] { IN
reindexed in a separate transaction. Those commands cannot be used inside
a transaction block when working on a partitioned table or index.
</para>
-
+
<para>
When using the <literal>TABLESPACE</literal> clause with
<command>REINDEX</command> on a partitioned index or table, only the
@@ -329,7 +329,7 @@ REINDEX [ ( <replaceable class="parameter">option</replaceable> [, ...] ) ] { IN
will be generated. Indexes on TOAST tables are rebuilt, but not moved
to the new tablespace.
</para>
-
+
<refsect2 id="sql-reindex-concurrently" xreflabel="Rebuilding Indexes Concurrently">
<title>Rebuilding Indexes Concurrently</title>
diff --git a/doc/src/sgml/ref/rollback_to.sgml b/doc/src/sgml/ref/rollback_to.sgml
index 3d5a241e1aa..27fa95cd1bc 100644
--- a/doc/src/sgml/ref/rollback_to.sgml
+++ b/doc/src/sgml/ref/rollback_to.sgml
@@ -112,14 +112,14 @@ DECLARE foo CURSOR FOR SELECT 1 UNION SELECT 2;
SAVEPOINT foo;
FETCH 1 FROM foo;
- ?column?
+ ?column?
----------
1
ROLLBACK TO SAVEPOINT foo;
FETCH 1 FROM foo;
- ?column?
+ ?column?
----------
2
diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml
index 8e5b83dfded..80bb8adcacc 100644
--- a/doc/src/sgml/ref/select.sgml
+++ b/doc/src/sgml/ref/select.sgml
@@ -1915,7 +1915,7 @@ SELECT * FROM t
UNION ALL
SELECT * FROM t
- x
+ x
--------------------
0.534150459803641
0.520092216785997
diff --git a/doc/src/sgml/ref/set_role.sgml b/doc/src/sgml/ref/set_role.sgml
index f02babf3af3..4e02322158a 100644
--- a/doc/src/sgml/ref/set_role.sgml
+++ b/doc/src/sgml/ref/set_role.sgml
@@ -115,7 +115,7 @@ RESET ROLE
<programlisting>
SELECT SESSION_USER, CURRENT_USER;
- session_user | current_user
+ session_user | current_user
--------------+--------------
peter | peter
@@ -123,7 +123,7 @@ SET ROLE 'paul';
SELECT SESSION_USER, CURRENT_USER;
- session_user | current_user
+ session_user | current_user
--------------+--------------
peter | paul
</programlisting>
diff --git a/doc/src/sgml/ref/set_session_auth.sgml b/doc/src/sgml/ref/set_session_auth.sgml
index e44e78ed8d6..f8fcafc1946 100644
--- a/doc/src/sgml/ref/set_session_auth.sgml
+++ b/doc/src/sgml/ref/set_session_auth.sgml
@@ -84,7 +84,7 @@ RESET SESSION AUTHORIZATION
<programlisting>
SELECT SESSION_USER, CURRENT_USER;
- session_user | current_user
+ session_user | current_user
--------------+--------------
peter | peter
@@ -92,7 +92,7 @@ SET SESSION AUTHORIZATION 'paul';
SELECT SESSION_USER, CURRENT_USER;
- session_user | current_user
+ session_user | current_user
--------------+--------------
paul | paul
</programlisting>
diff --git a/doc/src/sgml/ref/show.sgml b/doc/src/sgml/ref/show.sgml
index 93789ee0be0..b3747b119f9 100644
--- a/doc/src/sgml/ref/show.sgml
+++ b/doc/src/sgml/ref/show.sgml
@@ -167,7 +167,7 @@ SHOW geqo;
Show all settings:
<programlisting>
SHOW ALL;
- name | setting | description
+ name | setting | description
-------------------------+---------+-------------------------------------------------
allow_system_table_mods | off | Allows modifications of the structure of ...
.