summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorThomas G. Lockhart1998-04-04 16:34:23 +0000
committerThomas G. Lockhart1998-04-04 16:34:23 +0000
commite47e0e69234a0afca4c5aa524c269077dfd3e580 (patch)
tree1ee99a82fff9a3565b7875bc86cf0789761e25fb
parentc452ddcac67dc2eb52c2744cdc0ebe5530ab591f (diff)
Include example of table loading using the COPY command.
-rw-r--r--doc/src/sgml/query-ug.sgml11
1 files changed, 10 insertions, 1 deletions
diff --git a/doc/src/sgml/query-ug.sgml b/doc/src/sgml/query-ug.sgml
index a5fc3463a15..abd496f5f50 100644
--- a/doc/src/sgml/query-ug.sgml
+++ b/doc/src/sgml/query-ug.sgml
@@ -104,7 +104,16 @@ INSERT INTO weather
<Para>
You can also use the <Command>copy</Command> command to perform load large
amounts of data from flat (<Acronym>ASCII</Acronym>) files.
-</Para>
+This is usually faster because the data is read (or written) as a single atomic
+transaction directly to or from the target table. An example would be:
+
+<ProgramListing>
+COPY INTO weather FROM '/home/user/weather.txt'
+ USING DELIMITERS '|';
+</ProgramListing>
+
+where the path name for the source file must be available to the backend server
+machine, not just the client.
<Sect1>
<Title>Querying a Class</Title>