Learn how to connect to a PostgreSQL database 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).
To view details about data type mappings or to migrate data, see the PostgreSQL to Exasol migration script in our GitHub repository.
Prerequisites
-
The PostgreSQL server must be reachable from the Exasol system.
-
The user credentials in the connection must be valid.
Create connection
To create a connection, run the following statement. Replace the connection string and credentials as needed.
Copy
CREATE OR REPLACE CONNECTION JDBC_POSTGRESQL
TO 'jdbc:postgresql://192.168.99.100:5432/my_db'
USER 'username'
IDENTIFIED BY 'Exasoltest';To test the connection, run the following statement.
Copy
SELECT * FROM
(IMPORT FROM JDBC AT JDBC_POSTGRESQL
STATEMENT 'select ''Connection works'' '
);Load data
Use IMPORT to load data from a table or SQL statement using the connection that you created.
