diff --git a/doc/src/sgml/ecpg.sgml b/doc/src/sgml/ecpg.sgml index b7f785069f..95ec66867f 100644 --- a/doc/src/sgml/ecpg.sgml +++ b/doc/src/sgml/ecpg.sgml @@ -1041,7 +1041,7 @@ struct varchar_var { int len; char arr[180]; } var; - timestamp, date + <phrase id="ecpg-type-timestamp-date">timestamp, date</phrase> Here is a pattern for handling timestamp variables @@ -1206,7 +1206,7 @@ EXEC SQL END DECLARE SECTION; - bytea + <phrase id="ecpg-type-bytea">bytea</phrase> The handling of the bytea type is also similar to diff --git a/doc/src/sgml/file-fdw.sgml b/doc/src/sgml/file-fdw.sgml index 2413089ffe..2049e855dd 100644 --- a/doc/src/sgml/file-fdw.sgml +++ b/doc/src/sgml/file-fdw.sgml @@ -210,7 +210,7 @@ - Create a Foreign Table for PostgreSQL CSV Logs + <phrase id="csvlog-fdw">Create a Foreign Table for PostgreSQL CSV Logs</phrase> One of the obvious uses for file_fdw is to make diff --git a/doc/src/sgml/ref/alter_collation.sgml b/doc/src/sgml/ref/alter_collation.sgml index b51b3a2564..eac6c244fe 100644 --- a/doc/src/sgml/ref/alter_collation.sgml +++ b/doc/src/sgml/ref/alter_collation.sgml @@ -102,7 +102,7 @@ ALTER COLLATION name SET SCHEMA new_sche - Notes + <phrase id="sql-altercollation-notes-title">Notes</phrase> When using collations provided by the ICU library, the ICU-specific version diff --git a/doc/src/sgml/ref/alter_table.sgml b/doc/src/sgml/ref/alter_table.sgml index 0aa0f093f2..8a47e3f95e 100644 --- a/doc/src/sgml/ref/alter_table.sgml +++ b/doc/src/sgml/ref/alter_table.sgml @@ -1153,7 +1153,7 @@ WITH ( MODULUS numeric_literal, REM - Notes + <phrase id="sql-altertable-notes-title">Notes</phrase> The key word COLUMN is noise and can be omitted. diff --git a/doc/src/sgml/ref/clusterdb.sgml b/doc/src/sgml/ref/clusterdb.sgml index ed343dd7da..56c93543c2 100644 --- a/doc/src/sgml/ref/clusterdb.sgml +++ b/doc/src/sgml/ref/clusterdb.sgml @@ -15,7 +15,7 @@ PostgreSQL documentation - clusterdb + clusterdb cluster a PostgreSQL database diff --git a/doc/src/sgml/ref/commit_prepared.sgml b/doc/src/sgml/ref/commit_prepared.sgml index d938b65bbe..113c91b291 100644 --- a/doc/src/sgml/ref/commit_prepared.sgml +++ b/doc/src/sgml/ref/commit_prepared.sgml @@ -72,7 +72,7 @@ COMMIT PREPARED transaction_id - Examples + <phrase id="sql-commit-prepared-examples-title">Examples</phrase> Commit the transaction identified by the transaction identifier foobar: diff --git a/doc/src/sgml/ref/create_aggregate.sgml b/doc/src/sgml/ref/create_aggregate.sgml index b8cd2e7af9..1fb0164805 100644 --- a/doc/src/sgml/ref/create_aggregate.sgml +++ b/doc/src/sgml/ref/create_aggregate.sgml @@ -656,7 +656,7 @@ SELECT col FROM tab ORDER BY col USING sortop LIMIT 1; - Notes + <phrase id="sql-createaggregate-notes-title">Notes</phrase> In parameters that specify support function names, you can write diff --git a/doc/src/sgml/ref/create_foreign_table.sgml b/doc/src/sgml/ref/create_foreign_table.sgml index 37a45b26db..3e2d1e2e92 100644 --- a/doc/src/sgml/ref/create_foreign_table.sgml +++ b/doc/src/sgml/ref/create_foreign_table.sgml @@ -343,7 +343,7 @@ CREATE FOREIGN TABLE measurement_y2016m07 - Compatibility + <phrase id="sql-createforeigntable-compatibility-title">Compatibility</phrase> The CREATE FOREIGN TABLE command largely conforms to the diff --git a/doc/src/sgml/ref/create_index.sgml b/doc/src/sgml/ref/create_index.sgml index ad619cdcfe..e494457cb3 100644 --- a/doc/src/sgml/ref/create_index.sgml +++ b/doc/src/sgml/ref/create_index.sgml @@ -351,7 +351,7 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] - Index Storage Parameters + <phrase id="sql-createindex-storage-parameters-title">Index Storage Parameters</phrase> The optional WITH clause specifies storage @@ -487,7 +487,7 @@ CREATE [ UNIQUE ] INDEX [ CONCURRENTLY ] [ [ IF NOT EXISTS ] - Building Indexes Concurrently + <phrase id="sql-createindex-concurrently-title">Building Indexes Concurrently</phrase> index diff --git a/doc/src/sgml/ref/create_table.sgml b/doc/src/sgml/ref/create_table.sgml index 22dbc07b23..7a37e11458 100644 --- a/doc/src/sgml/ref/create_table.sgml +++ b/doc/src/sgml/ref/create_table.sgml @@ -1244,7 +1244,7 @@ WITH ( MODULUS numeric_literal, REM - Storage Parameters + <phrase id="sql-createtable-storage-parameters-title">Storage Parameters</phrase> storage parameters @@ -1854,7 +1854,7 @@ CREATE TABLE cities_partdef - Compatibility + <phrase id="sql-createtable-compatibility-title">Compatibility</phrase> The CREATE TABLE command conforms to the diff --git a/doc/src/sgml/ref/create_view.sgml b/doc/src/sgml/ref/create_view.sgml index e7a7e9fae2..c402933cd3 100644 --- a/doc/src/sgml/ref/create_view.sgml +++ b/doc/src/sgml/ref/create_view.sgml @@ -284,7 +284,7 @@ CREATE VIEW vista AS SELECT text 'Hello World' AS hello; - Updatable Views + <phrase id="sql-createview-updatable-views-title">Updatable Views</phrase> updatable views diff --git a/doc/src/sgml/ref/declare.sgml b/doc/src/sgml/ref/declare.sgml index 34ca9df243..1046ca6b1b 100644 --- a/doc/src/sgml/ref/declare.sgml +++ b/doc/src/sgml/ref/declare.sgml @@ -140,7 +140,7 @@ DECLARE name [ BINARY ] [ INSENSITI - Notes + <phrase id="sql-declare-notes-title">Notes</phrase> Normal cursors return data in text format, the same as a diff --git a/doc/src/sgml/ref/do.sgml b/doc/src/sgml/ref/do.sgml index a3a4877e80..51f5b01ef7 100644 --- a/doc/src/sgml/ref/do.sgml +++ b/doc/src/sgml/ref/do.sgml @@ -101,7 +101,7 @@ DO [ LANGUAGE lang_name ] - Examples + <phrase id="sql-do-examples-title">Examples</phrase> Grant all privileges on all views in schema public to role webuser: diff --git a/doc/src/sgml/ref/insert.sgml b/doc/src/sgml/ref/insert.sgml index 62e142fd8e..318ee6ee86 100644 --- a/doc/src/sgml/ref/insert.sgml +++ b/doc/src/sgml/ref/insert.sgml @@ -129,7 +129,7 @@ INSERT INTO table_name [ AS Parameters - Inserting + <phrase id="sql-inserting-params-title">Inserting</phrase> This section covers parameters that may be used when only @@ -303,7 +303,7 @@ INSERT INTO table_name [ AS - <literal>ON CONFLICT</literal> Clause + <phrase id="sql-on-conflict-title"><literal>ON CONFLICT</literal> Clause</phrase> UPSERT diff --git a/doc/src/sgml/ref/pg_dump.sgml b/doc/src/sgml/ref/pg_dump.sgml index 033eae9b46..3c9928a779 100644 --- a/doc/src/sgml/ref/pg_dump.sgml +++ b/doc/src/sgml/ref/pg_dump.sgml @@ -1313,7 +1313,7 @@ CREATE DATABASE foo WITH TEMPLATE template0; - Examples + <phrase id="pg-dump-examples-title">Examples</phrase> To dump a database called mydb into a SQL-script file: diff --git a/doc/src/sgml/ref/postgres-ref.sgml b/doc/src/sgml/ref/postgres-ref.sgml index 53dc05a78f..9faf8adc39 100644 --- a/doc/src/sgml/ref/postgres-ref.sgml +++ b/doc/src/sgml/ref/postgres-ref.sgml @@ -754,7 +754,7 @@ PostgreSQL documentation - Single-User Mode + <phrase id="app-postgres-single-user-title">Single-User Mode</phrase> To start a single-user mode server, use a command like diff --git a/doc/src/sgml/ref/postmaster.sgml b/doc/src/sgml/ref/postmaster.sgml index 311510a44d..7b544ed0b6 100644 --- a/doc/src/sgml/ref/postmaster.sgml +++ b/doc/src/sgml/ref/postmaster.sgml @@ -15,7 +15,7 @@ PostgreSQL documentation - postmaster + postmaster PostgreSQL database server diff --git a/doc/src/sgml/ref/prepare.sgml b/doc/src/sgml/ref/prepare.sgml index 3d799b5b57..e9f4dcc984 100644 --- a/doc/src/sgml/ref/prepare.sgml +++ b/doc/src/sgml/ref/prepare.sgml @@ -200,7 +200,7 @@ PREPARE name [ ( - Examples + <phrase id="sql-prepare-examples-title">Examples</phrase> Create a prepared statement for an INSERT statement, and then execute it: diff --git a/doc/src/sgml/ref/prepare_transaction.sgml b/doc/src/sgml/ref/prepare_transaction.sgml index 5016ca287e..6db89a173b 100644 --- a/doc/src/sgml/ref/prepare_transaction.sgml +++ b/doc/src/sgml/ref/prepare_transaction.sgml @@ -147,7 +147,7 @@ PREPARE TRANSACTION transaction_id - Examples + <phrase id="sql-prepare-transaction-examples-title">Examples</phrase> Prepare the current transaction for two-phase commit, using foobar as the transaction identifier: diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index d7539ae743..ea103e0f32 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -3317,7 +3317,7 @@ select 1\; select 2\; select 3; - Patterns + <phrase id="app-psql-patterns-title">Patterns</phrase> patterns @@ -3410,7 +3410,7 @@ select 1\; select 2\; select 3; Advanced Features - Variables + <phrase id="app-psql-variables-title">Variables</phrase> psql provides variable substitution @@ -3963,7 +3963,7 @@ bar - <acronym>SQL</acronym> Interpolation + <phrase id="app-psql-interpolation-title"><acronym>SQL</acronym> Interpolation</phrase> A key feature of psql @@ -4048,7 +4048,7 @@ testdb=> INSERT INTO my_table VALUES (:'content'); - Prompting + <phrase id="app-psql-prompting-title">Prompting</phrase> The prompts psql issues can be customized @@ -4292,7 +4292,7 @@ $endif - Environment + <phrase id="app-psql-environment-title">Environment</phrase> @@ -4587,7 +4587,7 @@ PSQL_EDITOR_LINENUMBER_ARG='--line ' - Examples + <phrase id="app-psql-examples-title">Examples</phrase> The first example shows how to spread a command over several lines of diff --git a/doc/src/sgml/ref/reindexdb.sgml b/doc/src/sgml/ref/reindexdb.sgml index 1273dad807..5562e54a50 100644 --- a/doc/src/sgml/ref/reindexdb.sgml +++ b/doc/src/sgml/ref/reindexdb.sgml @@ -15,7 +15,7 @@ PostgreSQL documentation - reindexdb + reindexdb reindex a PostgreSQL database diff --git a/doc/src/sgml/ref/rollback_prepared.sgml b/doc/src/sgml/ref/rollback_prepared.sgml index 08821a6652..32e31c162f 100644 --- a/doc/src/sgml/ref/rollback_prepared.sgml +++ b/doc/src/sgml/ref/rollback_prepared.sgml @@ -72,7 +72,7 @@ ROLLBACK PREPARED transaction_id - Examples + <phrase id="sql-rollback-prepared-examples-title">Examples</phrase> Roll back the transaction identified by the transaction identifier foobar: diff --git a/doc/src/sgml/ref/select.sgml b/doc/src/sgml/ref/select.sgml index 06d611b64c..f149d58c1c 100644 --- a/doc/src/sgml/ref/select.sgml +++ b/doc/src/sgml/ref/select.sgml @@ -220,7 +220,7 @@ TABLE [ ONLY ] table_name [ * ] Parameters - <literal>WITH</literal> Clause + <phrase id="sql-with-title"><literal>WITH</literal> Clause</phrase> The WITH clause allows you to specify one or more @@ -329,7 +329,7 @@ TABLE [ ONLY ] table_name [ * ] - <literal>FROM</literal> Clause + <phrase id="sql-from-title"><literal>FROM</literal> Clause</phrase> The FROM clause specifies one or more source @@ -700,7 +700,7 @@ TABLE [ ONLY ] table_name [ * ] - <literal>WHERE</literal> Clause + <phrase id="sql-where-title"><literal>WHERE</literal> Clause</phrase> The optional WHERE clause has the general form @@ -717,7 +717,7 @@ WHERE condition - <literal>GROUP BY</literal> Clause + <phrase id="sql-groupby-title"><literal>GROUP BY</literal> Clause</phrase> The optional GROUP BY clause has the general form @@ -791,7 +791,7 @@ GROUP BY grouping_element [, ...] - <literal>HAVING</literal> Clause + <phrase id="sql-having-title"><literal>HAVING</literal> Clause</phrase> The optional HAVING clause has the general form @@ -834,7 +834,7 @@ HAVING condition - <literal>WINDOW</literal> Clause + <phrase id="sql-window-title"><literal>WINDOW</literal> Clause</phrase> The optional WINDOW clause has the general form @@ -1031,7 +1031,7 @@ EXCLUDE NO OTHERS - <command>SELECT</command> List + <phrase id="sql-select-list-title"><command>SELECT</command> List</phrase> The SELECT list (between the key words @@ -1112,7 +1112,7 @@ EXCLUDE NO OTHERS - <literal>DISTINCT</literal> Clause + <phrase id="sql-distinct-title"><literal>DISTINCT</literal> Clause</phrase> If SELECT DISTINCT is specified, all duplicate rows are @@ -1157,7 +1157,7 @@ SELECT DISTINCT ON (location) location, time, report - <literal>UNION</literal> Clause + <phrase id="sql-union-title"><literal>UNION</literal> Clause</phrase> The UNION clause has this general form: @@ -1210,7 +1210,7 @@ SELECT DISTINCT ON (location) location, time, report - <literal>INTERSECT</literal> Clause + <phrase id="sql-intersect-title"><literal>INTERSECT</literal> Clause</phrase> The INTERSECT clause has this general form: @@ -1258,7 +1258,7 @@ SELECT DISTINCT ON (location) location, time, report - <literal>EXCEPT</literal> Clause + <phrase id="sql-except-title"><literal>EXCEPT</literal> Clause</phrase> The EXCEPT clause has this general form: @@ -1302,7 +1302,7 @@ SELECT DISTINCT ON (location) location, time, report - <literal>ORDER BY</literal> Clause + <phrase id="sql-orderby-title"><literal>ORDER BY</literal> Clause</phrase> The optional ORDER BY clause has this general form: @@ -1400,7 +1400,7 @@ SELECT name FROM distributors ORDER BY code; - <literal>LIMIT</literal> Clause + <phrase id="sql-limit-title"><literal>LIMIT</literal> Clause</phrase> The LIMIT clause consists of two independent @@ -1482,7 +1482,7 @@ FETCH { FIRST | NEXT } [ count ] { - The Locking Clause + <phrase id="sql-for-update-share-title">The Locking Clause</phrase> FOR UPDATE, FOR NO KEY UPDATE, FOR SHARE diff --git a/doc/src/sgml/ref/vacuumdb.sgml b/doc/src/sgml/ref/vacuumdb.sgml index 41c7f3df79..c1dab78d10 100644 --- a/doc/src/sgml/ref/vacuumdb.sgml +++ b/doc/src/sgml/ref/vacuumdb.sgml @@ -15,7 +15,7 @@ PostgreSQL documentation - vacuumdb + vacuumdb garbage-collect and analyze a PostgreSQL database