ContextQMD
Back to Tooljet

PostgreSQL

docs/versioned_docs/version-2.50.0-LTS/data-sources/postgresql.md

3.20.154-lts2.6 KB
Original Source

ToolJet has the capability to connect to PostgreSQL databases for data retrieval and modification.

<div style={{paddingTop:'24px'}}>

Establishing a Connection

To establish a connection with the PostgreSQL data source, you can either click on the + Add new Data source button located on the query panel or navigate to the Data Sources page from the ToolJet dashboard and choose PostgreSQL as the data source.

ToolJet requires the following information to connect to your PostgreSQL database:

  • Host
  • Port
  • SSL
  • Database Name
  • Username
  • Password
  • Connection Options
  • SSL Certificate

Note: We recommend creating a new PostgreSQL database user to have control over ToolJet's access levels.

:::info Please make sure the Host/IP of the database is accessible from your VPC if you have self-hosted ToolJet. If you are using ToolJet cloud, please whitelist our IP. :::

</div> <div style={{paddingTop:'24px'}}>

Querying PostgreSQL

  1. Click on + Add button of the query manager at the bottom panel of the editor.
  2. Select the PostgreSQL datasource added in previous step.
  3. Select the query mode from the dropdown and enter the query.
  4. Click on the Preview button to preview the output or Click on the Run button to trigger the query.

SQL Mode

To execute SQL queries, select the SQL mode from the dropdown and enter your query in the editor.

sql
SELECT * FROM CUSTOMER

GUI Mode

Choose the GUI mode from the dropdown and select the operation Bulk update using primary key. Provide the Table name and the Primary key column name. Then, in the editor, input the records as an array of objects.

sql
[
  {
    "customer_id": 1,
    "country": "India"
  },
  {
    "customer_id": 2,
    "country": "USA"
  }
]

:::tip

</div>