OR 12.0 | Copy Statement

System Reference Summary > System Reference Summary > Statements > OpenROAD SQL Statements > Copy Statement

Was this helpful?

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.

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];

Last modified date: 06/25/2024