Vector 6.2 | Transfer Data from Traditional Ingres Table

User Guide > User Guide > Updating Data > Batch and Bulk Updates > Transfer Data from Traditional Ingres Table

Was this helpful?

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 X100 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

Last modified date: 04/23/2025