Loading Data from PostgreSQL
This section describes how you can connect PostgreSQL with Exasol and then load data. The driver for PostgreSQL is pre-installed with Exasol. You can see the driver details in the EXAoperation (Configuration > Software > JDBC Drivers tab).
Run Statement
Run the following statement to create a connection.
CREATE OR REPLACE CONNECTION JDBC_POSTGRESQL
TO 'jdbc:postgresql://192.168.99.100:5432/my_db'
USER 'username'
IDENTIFIED BY 'Exasoltest';
Run the following statement to test the connection.
Load Data
You can use the IMPORT statement to load data using the connection you created above. IMPORT supports loading data from a table or a SQL statement.
To view details about data type mappings or to migrate data, see the PostgreSQL to Exasol migration script in our GitHub repository.