Skip to main content

PostgreSQL

Connect to PostgreSQL.

Configuration​

The following values are needed to connect to PostgreSQL:

  • Address: URL / hostname:port of the instance
  • Database: database name to pull tables from
  • Username: user to authenticate as
  • Password: password used to authenticate

If your database requires SSL, you may also upload the SSL Root Cert file.

Datasets​

By default, each table in the database will be automatically indexed as a dataset within Predibase.

Connection Query Template​

CREATE CONNECTION postgres_connection
    CONNECTION_TYPE = POSTGRESQL
    DATABASE_ADDRESS = '127.0.0.1:5432'
    DATABASE_NAME = 'database'
    USERNAME = 'username'
    PASSWORD = 'password'