3. Statements : OpenROAD SQL Statements : Copy Statement
 
Share this page                  
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 'filename[, type]'
              [with_clause];