You can also use the COPY command to populate rows with values. This command copies from an ASCII file and inserts the values into the table rows. The path name of the file must be available to the backend server machine, since the backend server reads the file directly. COPY is also faster than insert because the data is read (or written) as a single atomic transaction directly to or from the target table. The syntax for COPY is:

  COPY  table FROM 'path of text file' USING DELIMITERS '|';