From 6b64704e4f918b10431b51f2739d3874ef999151 Mon Sep 17 00:00:00 2001
From: Bruce Momjian
Date: Sun, 4 Aug 2002 05:09:36 +0000
Subject: This patch fixes a probably harmless write of uninitialized memory in
the statistics collector and makes a number of corrections to the
documentation for SET, SHOW, and COPY.
Neil Conway
---
doc/src/sgml/ref/copy.sgml | 26 ++++++++++++--------------
doc/src/sgml/ref/set.sgml | 11 +++++++----
doc/src/sgml/ref/show.sgml | 20 +++++++++++++-------
3 files changed, 32 insertions(+), 25 deletions(-)
(limited to 'doc/src')
diff --git a/doc/src/sgml/ref/copy.sgml b/doc/src/sgml/ref/copy.sgml
index d09b6706dd0..5d2b3824197 100644
--- a/doc/src/sgml/ref/copy.sgml
+++ b/doc/src/sgml/ref/copy.sgml
@@ -1,5 +1,5 @@
@@ -57,7 +57,7 @@ COPY table [ ( column list
+ column
An optional list of columns to be copied. If no column list is
@@ -99,7 +99,8 @@ COPY table [ ( table [ ( delimiter
- The character that separates fields within each row (line) of the file.
+ The single character that separates fields within each row (line) of the file.
@@ -189,9 +190,7 @@ ERROR: reasonCOPY moves data between
PostgreSQL tables and standard file-system
- files.
-
- COPY TO copies the entire contents of a table
+ files. COPY TO copies the contents of a table
to a file, while COPY FROM copies
data from a file to a table (appending the data to
whatever is in the table already).
@@ -200,7 +199,7 @@ ERROR: reason
If a list of columns is specified, COPY will
only copy the data in the specified columns to or from the file.
- If there are any columns in the table that are not in the file,
+ If there are any columns in the table that are not in the column list,
COPY FROM will insert the default values for
those columns.
@@ -249,8 +248,8 @@ ERROR: reason
By default, a text copy uses a tab ("\t") character as a delimiter
between fields. The field delimiter may be changed to any other
- single character with the keyword DELIMITER. Characters in data
- fields that happen to match the delimiter character will be
+ single character with the keyword . Characters
+ in data fields that happen to match the delimiter character will be
backslash quoted.
@@ -635,15 +634,14 @@ OIDs to be shown as NULL if that ever proves desirable.
Usage
-The following example copies a table to standard output,
- using a vertical bar (|) as the field
- delimiter:
+ The following example copies a table to standard output,
+ using a vertical bar (|) as the field delimiter:
COPY country TO stdout WITH DELIMITER '|';
- To copy data from a Unix file into a table country:
+ To copy data from a Unix file into the country table:
COPY country FROM '/usr1/proj/bray/sql/country_data';
diff --git a/doc/src/sgml/ref/set.sgml b/doc/src/sgml/ref/set.sgml
index 359fb85b2ec..02fe51f6951 100644
--- a/doc/src/sgml/ref/set.sgml
+++ b/doc/src/sgml/ref/set.sgml
@@ -1,5 +1,5 @@
@@ -404,7 +404,8 @@ SELECT setseed(value);
- ERROR: not a valid option name: name
+ ERROR: 'name is not a
+ valid option name
The parameter you tried to set does not exist.
@@ -413,7 +414,8 @@ SELECT setseed(value);
- ERROR: permission denied
+ ERROR: 'name':
+ permission denied
You must be a superuser to alter certain settings.
@@ -422,7 +424,8 @@ SELECT setseed(value);
- ERROR: name can only be set at start-up
+ ERROR: 'name' cannot
+ be changed after server start
Some parameters are fixed once the server is started.
diff --git a/doc/src/sgml/ref/show.sgml b/doc/src/sgml/ref/show.sgml
index ad5565cf053..53d0772ab08 100644
--- a/doc/src/sgml/ref/show.sgml
+++ b/doc/src/sgml/ref/show.sgml
@@ -1,5 +1,5 @@
@@ -54,7 +54,11 @@ SHOW ALL
SHOW will display the current setting of a
run-time parameter. These variables can be set using the
- SET statement or are determined at session start.
+ SET statement, by editing the
+ postgresql.conf, through the
+ PGOPTIONS environmental variable, or through a
+ command-line flag when starting the
+ postmaster.
@@ -64,10 +68,11 @@ SHOW ALL
- ERROR: not a valid option name: name
+ ERROR: Option 'name'
+ is not recognized
- Message returned if variable does
+ Message returned if name does
not stand for an existing parameter.
@@ -81,24 +86,25 @@ SHOW ALL
Show the current DateStyle setting:
-
+
SHOW DateStyle;
DateStyle
---------------------------------------
ISO with US (NonEuropean) conventions
(1 row)
-
+
Show the current genetic optimizer (geqo) setting:
+
SHOW GEQO;
geqo
------
on
(1 row)
-
+
--
cgit v1.2.3