diff options
| author | Daniel Gustafsson <dgustafsson@postgresql.org> | 2022-08-22 15:08:45 +0200 |
|---|---|---|
| committer | Daniel Gustafsson <dgustafsson@postgresql.org> | 2022-08-22 15:08:45 +0200 |
| commit | e2fe0aedd00eae89e6d00bca5c598d1ac31b266a (patch) | |
| tree | 55bcacf1f39d0288b19a82a4d928ee2fcdbccd64 | |
| parent | f0b013b0fc0a53de0ffe610b403125affb9c6094 (diff) | |
| download | postgresql-e2fe0aedd00eae89e6d00bca5c598d1ac31b266a.tar.gz postgresql-e2fe0aedd00eae89e6d00bca5c598d1ac31b266a.zip | |
doc: Minor wordsmithing to COPY docs
Perform some minor wordsmithing on two sentences in the COPY documentation
to make them clearer.
While there, also ensure to wrap a few occurrences of CSV in <literal>
which were missing this.
Reported-by: Eric Mutta <eric.mutta@gmail.com>
Reviewed-by: Tom Lane <tgl@sss.pgh.pa.us>
Discussion: https://postgr.es/m/166104548566.654.11680826843612576896@wrigleys.postgresql.org
| -rw-r--r-- | doc/src/sgml/ref/copy.sgml | 12 |
1 files changed, 6 insertions, 6 deletions
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml index 63afa0d97e0..c25b52d0cb2 100644 --- a/doc/src/sgml/ref/copy.sgml +++ b/doc/src/sgml/ref/copy.sgml @@ -157,10 +157,10 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable </para> <para> Note that the command is invoked by the shell, so if you need to pass - any arguments to shell command that come from an untrusted source, you + any arguments that come from an untrusted source, you must be careful to strip or escape any special characters that might have a special meaning for the shell. For security reasons, it is best - to use a fixed command string, or at least avoid passing any user input + to use a fixed command string, or at least avoid including any user input in it. </para> </listitem> @@ -227,7 +227,7 @@ COPY { <replaceable class="parameter">table_name</replaceable> [ ( <replaceable <para> Note that all other sessions will immediately be able to see the data once it has been successfully loaded. This violates the normal rules - of MVCC visibility and users specifying should be aware of the + of MVCC visibility and users should be aware of the potential problems this might cause. </para> </listitem> @@ -708,7 +708,7 @@ COPY <replaceable class="parameter">count</replaceable> Separated Value (<literal>CSV</literal>) file format used by many other programs, such as spreadsheets. Instead of the escaping rules used by <productname>PostgreSQL</productname>'s standard text format, it - produces and recognizes the common CSV escaping mechanism. + produces and recognizes the common <literal>CSV</literal> escaping mechanism. </para> <para> @@ -766,7 +766,7 @@ COPY <replaceable class="parameter">count</replaceable> <note> <para> - CSV format will both recognize and produce CSV files with quoted + <literal>CSV</literal> format will both recognize and produce <literal>CSV</literal> files with quoted values containing embedded carriage returns and line feeds. Thus the files are not strictly one line per table row like text-format files. @@ -775,7 +775,7 @@ COPY <replaceable class="parameter">count</replaceable> <note> <para> - Many programs produce strange and occasionally perverse CSV files, + Many programs produce strange and occasionally perverse <literal>CSV</literal> files, so the file format is more a convention than a standard. Thus you might encounter some files that cannot be imported using this mechanism, and <command>COPY</command> might produce files that other |