diff options
Diffstat (limited to 'doc/src/sgml/ref/psql-ref.sgml')
| -rw-r--r-- | doc/src/sgml/ref/psql-ref.sgml | 156 |
1 files changed, 78 insertions, 78 deletions
diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml index 8cbe0569cf4..e520cdf3ba1 100644 --- a/doc/src/sgml/ref/psql-ref.sgml +++ b/doc/src/sgml/ref/psql-ref.sgml @@ -3,7 +3,7 @@ doc/src/sgml/ref/psql-ref.sgml PostgreSQL documentation --> -<refentry id="APP-PSQL"> +<refentry id="app-psql"> <indexterm zone="app-psql"> <primary>psql</primary> </indexterm> @@ -45,7 +45,7 @@ PostgreSQL documentation </para> </refsect1> - <refsect1 id="R1-APP-PSQL-3"> + <refsect1 id="r1-app-psql-3"> <title>Options</title> <variablelist> @@ -629,7 +629,7 @@ EOF <refsect1> <title>Usage</title> - <refsect2 id="R2-APP-PSQL-connecting"> + <refsect2 id="r2-app-psql-connecting"> <title>Connecting to a Database</title> <para> @@ -701,7 +701,7 @@ $ <userinput>psql postgresql://dbmaster:5433/mydb?sslmode=require</userinput> </para> </refsect2> - <refsect2 id="R2-APP-PSQL-4"> + <refsect2 id="r2-app-psql-4"> <title>Entering SQL Commands</title> <para> @@ -730,8 +730,8 @@ testdb=> <para> Whenever a command is executed, <application>psql</application> also polls for asynchronous notification events generated by - <xref linkend="SQL-LISTEN"> and - <xref linkend="SQL-NOTIFY">. + <xref linkend="sql-listen"> and + <xref linkend="sql-notify">. </para> <para> @@ -741,7 +741,7 @@ testdb=> </para> </refsect2> - <refsect2 id="APP-PSQL-meta-commands"> + <refsect2 id="app-psql-meta-commands"> <title>Meta-Commands</title> <para> @@ -779,7 +779,7 @@ testdb=> If an unquoted colon (<literal>:</literal>) followed by a <application>psql</application> variable name appears within an argument, it is replaced by the variable's value, as described in <xref - linkend="APP-PSQL-interpolation" endterm="APP-PSQL-interpolation-title">. + linkend="app-psql-interpolation" endterm="app-psql-interpolation-title">. The forms <literal>:'<replaceable>variable_name</replaceable>'</literal> and <literal>:"<replaceable>variable_name</replaceable>"</literal> described there work as well. @@ -949,7 +949,7 @@ testdb=> </listitem> </varlistentry> - <varlistentry id="APP-PSQL-meta-commands-copy"> + <varlistentry id="app-psql-meta-commands-copy"> <term><literal>\copy { <replaceable class="parameter">table</replaceable> [ ( <replaceable class="parameter">column_list</replaceable> ) ] | ( <replaceable class="parameter">query</replaceable> ) } { <literal>from</literal> | <literal>to</literal> } { <replaceable class="parameter">'filename'</replaceable> | program <replaceable class="parameter">'command'</replaceable> | stdin | stdout | pstdin | pstdout } @@ -958,7 +958,7 @@ testdb=> <listitem> <para> Performs a frontend (client) copy. This is an operation that - runs an <acronym>SQL</acronym> <xref linkend="SQL-COPY"> + runs an <acronym>SQL</acronym> <xref linkend="sql-copy"> command, but instead of the server reading or writing the specified file, <application>psql</application> reads or writes the file and @@ -1028,7 +1028,7 @@ testdb=> </varlistentry> - <varlistentry id="APP-PSQL-meta-commands-crosstabview"> + <varlistentry id="app-psql-meta-commands-crosstabview"> <term><literal>\crosstabview [ <replaceable class="parameter">colV</replaceable> [ <replaceable class="parameter">colH</replaceable> @@ -1102,7 +1102,7 @@ testdb=> <varlistentry> - <term><literal>\d[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\d[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1116,7 +1116,7 @@ testdb=> also shown. For foreign tables, the associated foreign server is shown as well. (<quote>Matching the pattern</quote> is defined in - <xref linkend="APP-PSQL-patterns" endterm="APP-PSQL-patterns-title"> + <xref linkend="app-psql-patterns" endterm="app-psql-patterns-title"> below.) </para> @@ -1131,7 +1131,7 @@ testdb=> more information is displayed: any comments associated with the columns of the table are shown, as is the presence of OIDs in the table, the view definition if the relation is a view, a non-default - <link linkend="SQL-CREATETABLE-REPLICA-IDENTITY">replica + <link linkend="sql-createtable-replica-identity">replica identity</link> setting. </para> @@ -1155,7 +1155,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\da[S] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\da[S] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1171,7 +1171,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dA[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dA[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1185,7 +1185,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\db[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\db[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1201,7 +1201,7 @@ testdb=> <varlistentry> - <term><literal>\dc[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dc[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists conversions between character-set encodings. @@ -1219,7 +1219,7 @@ testdb=> <varlistentry> - <term><literal>\dC[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dC[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists type casts. @@ -1234,7 +1234,7 @@ testdb=> <varlistentry> - <term><literal>\dd[S] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dd[S] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Shows the descriptions of objects of type <literal>constraint</literal>, @@ -1263,7 +1263,7 @@ testdb=> <varlistentry> - <term><literal>\dD[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dD[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists domains. If <replaceable @@ -1280,7 +1280,7 @@ testdb=> <varlistentry> - <term><literal>\ddp [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\ddp [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists default access privilege settings. An entry is shown for @@ -1302,12 +1302,12 @@ testdb=> <varlistentry> - <term><literal>\dE[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> - <term><literal>\di[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> - <term><literal>\dm[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> - <term><literal>\ds[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> - <term><literal>\dt[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> - <term><literal>\dv[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dE[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\di[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dm[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\ds[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dt[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dv[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1333,7 +1333,7 @@ testdb=> <varlistentry> - <term><literal>\des[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\des[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists foreign servers (mnemonic: <quote>external @@ -1349,7 +1349,7 @@ testdb=> <varlistentry> - <term><literal>\det[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\det[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists foreign tables (mnemonic: <quote>external tables</quote>). @@ -1364,7 +1364,7 @@ testdb=> <varlistentry> - <term><literal>\deu[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\deu[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists user mappings (mnemonic: <quote>external @@ -1387,7 +1387,7 @@ testdb=> <varlistentry> - <term><literal>\dew[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dew[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists foreign-data wrappers (mnemonic: <quote>external @@ -1403,7 +1403,7 @@ testdb=> <varlistentry> - <term><literal>\df[antwS+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\df[antwS+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1437,7 +1437,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dF[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dF[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists text search configurations. @@ -1451,7 +1451,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dFd[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dFd[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists text search dictionaries. @@ -1465,7 +1465,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dFp[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dFp[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists text search parsers. @@ -1479,7 +1479,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dFt[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dFt[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists text search templates. @@ -1493,7 +1493,7 @@ testdb=> <varlistentry> - <term><literal>\dg[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dg[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists database roles. @@ -1523,7 +1523,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dL[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dL[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists procedural languages. If <replaceable @@ -1540,7 +1540,7 @@ testdb=> <varlistentry> - <term><literal>\dn[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dn[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> @@ -1557,7 +1557,7 @@ testdb=> <varlistentry> - <term><literal>\do[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\do[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists operators with their operand and result types. @@ -1575,7 +1575,7 @@ testdb=> <varlistentry> - <term><literal>\dO[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dO[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists collations. @@ -1595,7 +1595,7 @@ testdb=> <varlistentry> - <term><literal>\dp [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dp [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists tables, views and sequences with their @@ -1616,7 +1616,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\drds [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">role-pattern</replaceable></link> [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">database-pattern</replaceable></link> ] ]</literal></term> + <term><literal>\drds [ <link linkend="app-psql-patterns"><replaceable class="parameter">role-pattern</replaceable></link> [ <link linkend="app-psql-patterns"><replaceable class="parameter">database-pattern</replaceable></link> ] ]</literal></term> <listitem> <para> Lists defined configuration settings. These settings can be @@ -1638,7 +1638,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dRp[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dRp[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists replication publications. @@ -1652,7 +1652,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dRs[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dRs[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists replication subscriptions. @@ -1666,7 +1666,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dT[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dT[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists data types. @@ -1683,7 +1683,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\du[S+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\du[S+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists database roles. @@ -1702,7 +1702,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dx[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dx[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists installed extensions. @@ -1716,7 +1716,7 @@ testdb=> </varlistentry> <varlistentry> - <term><literal>\dy[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\dy[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists event triggers. @@ -2027,7 +2027,7 @@ CREATE INDEX <para> Sends the current query buffer to the server and stores the query's output into <application>psql</application> variables (see <xref - linkend="APP-PSQL-variables" endterm="APP-PSQL-variables-title">). + linkend="app-psql-variables" endterm="app-psql-variables-title">). The query to be executed must return exactly one row. Each column of the row is stored into a separate variable, named the same as the column. For example: @@ -2253,7 +2253,7 @@ SELECT <varlistentry> - <term><literal>\l[+]</literal> or <literal>\list[+] [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\l[+]</literal> or <literal>\list[+] [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> List the databases in the server and show their names, owners, @@ -2831,8 +2831,8 @@ lo_import 152801 <para> Illustrations of how these different formats look can be seen in - the <xref linkend="APP-PSQL-examples" - endterm="APP-PSQL-examples-title"> section. + the <xref linkend="app-psql-examples" + endterm="app-psql-examples-title"> section. </para> <tip> @@ -2917,8 +2917,8 @@ lo_import 152801 <para> Valid variable names can contain letters, digits, and underscores. See the section <xref - linkend="APP-PSQL-variables" - endterm="APP-PSQL-variables-title"> below for details. + linkend="app-psql-variables" + endterm="app-psql-variables-title"> below for details. Variable names are case-sensitive. </para> @@ -2926,14 +2926,14 @@ lo_import 152801 Certain variables are special, in that they control <application>psql</application>'s behavior or are automatically set to reflect connection state. These variables are - documented in <xref linkend="APP-PSQL-variables" - endterm="APP-PSQL-variables-title">, below. + documented in <xref linkend="app-psql-variables" + endterm="app-psql-variables-title">, below. </para> <note> <para> This command is unrelated to the <acronym>SQL</acronym> - command <xref linkend="SQL-SET">. + command <xref linkend="sql-set">. </para> </note> </listitem> @@ -3070,8 +3070,8 @@ testdb=> <userinput>\setenv LESS -imx4F</userinput> Most variables that control <application>psql</application>'s behavior cannot be unset; instead, an <literal>\unset</literal> command is interpreted as setting them to their default values. - See <xref linkend="APP-PSQL-variables" - endterm="APP-PSQL-variables-title">, below. + See <xref linkend="app-psql-variables" + endterm="app-psql-variables-title">, below. </para> </listitem> </varlistentry> @@ -3131,7 +3131,7 @@ testdb=> <userinput>\setenv LESS -imx4F</userinput> <varlistentry> - <term><literal>\z [ <link linkend="APP-PSQL-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> + <term><literal>\z [ <link linkend="app-psql-patterns"><replaceable class="parameter">pattern</replaceable></link> ]</literal></term> <listitem> <para> Lists tables, views and sequences with their @@ -3229,8 +3229,8 @@ select 1\; select 2\; select 3; </variablelist> </para> - <refsect3 id="APP-PSQL-patterns"> - <title id="APP-PSQL-patterns-title">Patterns</title> + <refsect3 id="app-psql-patterns"> + <title id="app-psql-patterns-title">Patterns</title> <indexterm> <primary>patterns</primary> @@ -3322,8 +3322,8 @@ select 1\; select 2\; select 3; <refsect2> <title>Advanced Features</title> - <refsect3 id="APP-PSQL-variables"> - <title id="APP-PSQL-variables-title">Variables</title> + <refsect3 id="app-psql-variables"> + <title id="app-psql-variables-title">Variables</title> <para> <application>psql</application> provides variable substitution @@ -3347,8 +3347,8 @@ testdb=> <userinput>\echo :foo</userinput> bar </programlisting> This works in both regular SQL commands and meta-commands; there is - more detail in <xref linkend="APP-PSQL-interpolation" - endterm="APP-PSQL-interpolation-title">, below. + more detail in <xref linkend="app-psql-interpolation" + endterm="app-psql-interpolation-title">, below. </para> <para> @@ -3742,8 +3742,8 @@ bar <para> These specify what the prompts <application>psql</application> issues should look like. See <xref - linkend="APP-PSQL-prompting" - endterm="APP-PSQL-prompting-title"> below. + linkend="app-psql-prompting" + endterm="app-psql-prompting-title"> below. </para> </listitem> </varlistentry> @@ -3875,8 +3875,8 @@ bar </refsect3> - <refsect3 id="APP-PSQL-interpolation"> - <title id="APP-PSQL-interpolation-title"><acronym>SQL</acronym> Interpolation</title> + <refsect3 id="app-psql-interpolation"> + <title id="app-psql-interpolation-title"><acronym>SQL</acronym> Interpolation</title> <para> A key feature of <application>psql</application> @@ -3960,8 +3960,8 @@ testdb=> <userinput>INSERT INTO my_table VALUES (:'content');</userinput> </refsect3> - <refsect3 id="APP-PSQL-prompting"> - <title id="APP-PSQL-prompting-title">Prompting</title> + <refsect3 id="app-psql-prompting"> + <title id="app-psql-prompting-title">Prompting</title> <para> The prompts <application>psql</application> issues can be customized @@ -4118,8 +4118,8 @@ testdb=> <userinput>INSERT INTO my_table VALUES (:'content');</userinput> <para> The value of the <application>psql</application> variable <replaceable class="parameter">name</replaceable>. See the - section <xref linkend="APP-PSQL-variables" - endterm="APP-PSQL-variables-title"> for details. + section <xref linkend="app-psql-variables" + endterm="app-psql-variables-title"> for details. </para> </listitem> </varlistentry> @@ -4499,8 +4499,8 @@ PSQL_EDITOR_LINENUMBER_ARG='--line ' </refsect1> - <refsect1 id="APP-PSQL-examples"> - <title id="APP-PSQL-examples-title">Examples</title> + <refsect1 id="app-psql-examples"> + <title id="app-psql-examples-title">Examples</title> <para> The first example shows how to spread a command over several lines of |