Open tbk303 opened 13 years ago
luciddb has an "import" command that allows data to be imported from a foreign source, e.g.
create or replace server jdbc_link foreign data wrapper sys_jdbc options( driver_class 'org.postgresql.Driver', url 'jdbc:postgresql://localhost/db', user_name 'postgres', table_types 'TABLE', fetch_size '10000', autocommit 'false');
import foreign schema "public" from server jdbc_link into extraction_schema;
However, as henplus also has an "import" command, the statement above won't be able to execute successfully.
Is there any workaround to this? Thanks.
Submitted:
Sok Ann Yap ( sayap ) - 2009-05-19 07:44:53 UTC
luciddb has an "import" command that allows data to be imported from a foreign source, e.g.
create or replace server jdbc_link foreign data wrapper sys_jdbc options( driver_class 'org.postgresql.Driver', url 'jdbc:postgresql://localhost/db', user_name 'postgres', table_types 'TABLE', fetch_size '10000', autocommit 'false');
import foreign schema "public" from server jdbc_link into extraction_schema;
However, as henplus also has an "import" command, the statement above won't be able to execute successfully.
Is there any workaround to this? Thanks.