Skip to main content

PostgreSQL

Use the PostgreSQL connector to perform various operations such as executing custom queries, managing databases, and more. This connector allows you to run SQL queries on your PostgreSQL instance directly from Boltic. You will need a valid PostgreSQL connection to get started.

Requirements

To use the PostgreSQL connector, you need:

  • Access to a PostgreSQL server.
  • PostgreSQL credentials (username and password).
  • The PostgreSQL server must be accessible over the internet or via a secure network.

Supported Authentication Methods

  • Username and Password
  • SSH Configuration (Optional)

Basic Operations

PostgreSQL Connection

  • Set up a PostgreSQL connection to execute queries and manage your database resources.

Database Operations

  • Execute Query: Run custom SQL queries directly on your PostgreSQL server.

Query

  • Enter your Query: Specify the SQL query you want to execute. This can include operations like selecting, inserting, updating, or deleting data within your database.

Example Operations

Database

  • Execute a Query: Run SQL commands (e.g., SELECT, UPDATE, INSERT, DELETE) on your PostgreSQL database.

Support

For more detailed instructions on setting up your PostgreSQL connection, refer to the Boltic documentation or contact Boltic support.