Reload a Table with Unformatted Copy
Use the following form of the COPY statement to reload a table from a binary file produced by an unformatted copy:
COPY [TABLE] [schema.]tablename () FROM 'output_filename'
[standard-with-clauses]
[bulk-copy-with-clauses]
This form of the COPY FROM statement must be used to reload from a binary file (that is, one created with an empty column list in the COPY INTO statement).
For example, the following statement copies the binary data from the dept_file file into the new_dept_table table:
COPY new_dept_table () FROM 'dept_file'
The new_dept_table must have been created with the same column and data type specifications as in the original dept table. If the table characteristics allow, include bulk copy (see
Bulk Copying) WITH clauses.
Last modified date: 08/28/2024