Reload a Table with Unformatted Copy

Database Administrator Guide > Database Administrator Guide > Populating Tables > Unformatted Copying > Reload a Table with Unformatted Copy

Was this helpful?

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: 11/28/2023