diff options
Diffstat (limited to 'doc/src/sgml/ref')
| -rw-r--r-- | doc/src/sgml/ref/create_index.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/explain.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pgarchivecleanup.sgml | 3 | ||||
| -rw-r--r-- | doc/src/sgml/ref/pgtestfsync.sgml | 2 | ||||
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 14 | ||||
| -rw-r--r-- | doc/src/sgml/ref/reindex.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/rollback_to.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/select.sgml | 2 | ||||
| -rw-r--r-- | doc/src/sgml/ref/set_role.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/set_session_auth.sgml | 4 | ||||
| -rw-r--r-- | doc/src/sgml/ref/show.sgml | 2 |
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=> <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=> <userinput>\df int*pl * bigint</userinput> with the <command>\crosstabview</command> command: <programlisting> testdb=> <userinput>SELECT first, second, first > 2 AS gt2 FROM my_table;</userinput> - first | second | gt2 + first | second | gt2 -------+--------+----- 1 | one | f 2 | two | f @@ -5132,11 +5132,11 @@ testdb=> <userinput>SELECT first, second, first > 2 AS gt2 FROM my_table;< (4 rows) testdb=> <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=> <userinput>SELECT t1.first as "A", t2.first+100 AS "B", t1.first*(t2 testdb(> <userinput>row_number() over(order by t2.first) AS ord</userinput> testdb(> <userinput>FROM my_table t1 CROSS JOIN my_table t2 ORDER BY 1 DESC</userinput> testdb(> <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 ... . |
