Skip to main content
Version: v2

Connecting to PostgreSQL

Before starting

Before you begin, learn how to create a data source

Step 1: Go to the Data Sources page

You can create a data source through the following two operations. The first is to click the "+" button on the sidebar Data Source or click the Create a Data Source button on the Overview page to create.

1_postgresql

Step 2: Set connection information

In the pop-up form, fill in and set the connection information, and click Submit to send.

3_postgresql

  • Name: database name, for display, can be modified later
  • Data Source Type: database type, please select PostgreSQL
  • URL: Please fill in <hostname>:<port> format, for example database-1.cboscstksckj.ap-northeast-1.rds.amazonaws.com:5432, 10.207.64.3:5432
  • Username: Username used for connection
  • Password: Password used for connection
  • Database Name: The database name of the connection
Info

Table Pattern feature is only available after version 2.4.3

  • Table Pattern: Can use Java regular expression to filter the tables you want to connect. E.g. public.r.* for selecting all tables under the public schema whose names start with the letter r.
  • Explore Timeout: If the database contains a large number of Tables, it is recommended to increase this parameter so that the Explorer can wait for a longer time

Step 3: Complete the build

After submitting, the PostgreSQL data source will show up in the sidebar in a few moments, and you can click to enter the data source details page.

4_postgresql