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.
Step 2: Set connection information
In the pop-up form, fill in and set the connection information, and click Submit to send.
Name
: database name, for display, can be modified laterData Source Type
: database type, please selectPostgreSQL
URL
: Please fill in<hostname>:<port>
format, for exampledatabase-1.cboscstksckj.ap-northeast-1.rds.amazonaws.com:5432
,10.207.64.3:5432
Username
: Username used for connectionPassword
: Password used for connectionDatabase 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 thepublic
schema whose names start with the letterr
.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.