From e47e0e69234a0afca4c5aa524c269077dfd3e580 Mon Sep 17 00:00:00 2001 From: "Thomas G. Lockhart" Date: Sat, 4 Apr 1998 16:34:23 +0000 Subject: [PATCH] Include example of table loading using the COPY command. --- doc/src/sgml/query-ug.sgml | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) diff --git a/doc/src/sgml/query-ug.sgml b/doc/src/sgml/query-ug.sgml index a5fc3463a1..abd496f5f5 100644 --- a/doc/src/sgml/query-ug.sgml +++ b/doc/src/sgml/query-ug.sgml @@ -104,7 +104,16 @@ INSERT INTO weather You can also use the copy command to perform load large amounts of data from flat (ASCII) files. - +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: + + +COPY INTO weather FROM '/home/user/weather.txt' + USING DELIMITERS '|'; + + +where the path name for the source file must be available to the backend server +machine, not just the client. Querying a Class -- 2.11.0