diff options
author | Thomas G. Lockhart | 1998-04-04 16:34:23 +0000 |
---|---|---|
committer | Thomas G. Lockhart | 1998-04-04 16:34:23 +0000 |
commit | e47e0e69234a0afca4c5aa524c269077dfd3e580 (patch) | |
tree | 1ee99a82fff9a3565b7875bc86cf0789761e25fb | |
parent | c452ddcac67dc2eb52c2744cdc0ebe5530ab591f (diff) |
Include example of table loading using the COPY command.
-rw-r--r-- | doc/src/sgml/query-ug.sgml | 11 |
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> |