Postgres

Postgres connection helps you connect to a Postgres database and run queries directly from Infoveave.

Adding a Postgres Connection

To create a new Postgres connection:

1. Go to the Database section.
2. Select Postgres from the available connectors.
3. Fill in the required connection details in the New Postgres Connection form.

Connection Parameters

When setting up a Postgres connection, you need to provide the following details:

Field	Description
Name	A unique name to identify your connection.
Port	Port number for Postgres (default is 5432).
Server	The Postgres server endpoint.
Username	Your Postgres database username.
Password	The corresponding password for the username.
Database	The Postgres database you want to connect to.
Schema	The schema inside the database to be used (optional).

Steps to Validate and Save

1. After filling in the details, click Validate to verify the connection.
2. If validation succeeds, click Save to store the connection.
3. You can now use Postgres as a datasource in your Infoveave workspace.

Example Use Case

With a Postgres connection configured, you can:

• Query and manage Postgres databases efficiently.
• Use advanced SQL features including JSON support, full-text search, and geospatial queries.
• Integrate Postgres data into Infoboards for dashboards, reports, and insights.