5. Populating Tables : COPY Statement Syntax
 
Share this page                  
COPY Statement Syntax
To load data from a table into a file or from a file into a table, use the COPY statement.
Each COPY statement must specify only one table name. An optional schema name can be specified. The TABLE keyword is optional and can be included for readability.
The table name is followed by a list in parentheses containing none, one, or more column format specifications, up to the total number of columns in the table. The column specifications depend on the type of copy being performed.
For details on the COPY statement, see the SQL Reference Guide.