Transfer Data from Traditional Ingres Table
Data can be transferred in either direction between traditional Ingres tables and Vector tables using either INSERT...SELECT or CREATE TABLE AS SELECT.
To transfer data from traditional Ingres using INSERT..SELECT
1. Create a destination table with VECTORWISE storage type:
CREATE TABLE dst (i INTEGER)
2. Issue INSERT...SELECT into that table:
INSERT INTO dst SELECT * FROM src
To transfer data from traditional Ingres using CREATE TABLE AS SELECT
Use a statement similar to the following:
CREATE TABLE dst AS SELECT FROM src
To create an Ingres table based on a table in Vector
Assuming that the default setting is to create a Vector table, use a statement similar to the following:
CREATE TABLE dst_ing AS SELECT FROM src_vw WITH STRUCTURE = HEAP
Note: You must be licensed to use HEAP tables in Vector.