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.