Copy Statement
The copy statement copies the contents of a table to a data file (copy into) or copies the contents of a file to a table (copy from). For more information on the copy statement, see Populating Tables in the Ingres Database Administrator Guide.
This statement has the following syntax:
copy [table] [schema.]table_name
([column_name = format [with null [(value)]]
{, column_name = format [with null [(value)]]}])
into | from | append 'filename[, type]'
[with_clause];