Loading Data from a File
If the data to be loaded into your database is stored in a file, use the COPY statement to load the data. You can also use COPY to load data from a data stream.
In its basic form, use COPY as follows:
COPY target-table FROM data-source
For more information, see the following sections of the Vertica documentation:
- Using COPY and COPY LOCAL in the Administrator's Guide
- COPY in the SQL Reference Manual
- COPY LOCAL in the SQL Reference Manual