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.