PostgreSQL is an open-source relational database management system that supports advanced data storage and retrieval.
Integrating it with your application enhances data management by providing powerful database functionalities and reliable performance.
Authentication
Before you begin, make sure you have the following information:
Connection Name: Choose a meaningful name for your connection. This name helps you identify the connection within your application or integration settings. It could be something descriptive like "My App PostgreSQL".Database Host: The PostgreSQL database host's IP address or DNS.Note: For URL-based hostnames, exclude the http:// or https:// part. For example, if the hostname URL is https://postgresql-qa.xxxx.ap-south-1.rds.amazonaws.com, enter postgresql-qa.xxxx.ap-south-1.rds.amazonaws.com.Database Port: The port on which your PostgreSQL server listens for connections. Default value: 5432.Database User: The authenticated user who has the permissions to read tables in your database.Database Password: The password for the database user.Schema Name: This represents the schema or user namespace within the PostgreSQL database that contains tables, views, and other database objects.Connect through SSH: Enable this option to connect to Unifyapps using an SSH tunnel, instead of directly connecting to your PostgreSQL database host. This provides an additional level of security to your database by not exposing your PostgreSQL setup to the public.SSH Host: Enter the hostname or IP address of the SSH server that acts as the gateway to your database. Example: ssh.example.com or 203.0.113.1SSH Port: Specify the port number on which the SSH server is listening. Default is usually 22, but it may be different for security reasons.SSH User: Provide the username for authenticating with the SSH server. This is typically the user account on the remote server with necessary permissions.RSA Private Key: Provide the RSA private key corresponding to the public key stored on the SSH server.Client Certificate: Obtain a valid client certificate issued by a trusted Certificate Authority (CA). This certificate authenticates your client to the database server.SSL Certificate Key: This is the private key corresponding to your client certificate.Server Certificate: Obtain the database server's SSL certificate. This certificate verifies the server's identity to your client. Often provided by your database administrator or hosting service.
Actions
The following actions are available to create custom automations on the Unifyapps platform:
Action | Description |
| Creates a snapshot of a table and stores it in S3. |
| Creates a new table and inserts a record into it. |
| Deletes rows from a table in PostgreSQL. |
| Executes a SQL statement in a PostgreSQL database. |
| Exports the result of a query as a CSV file. |
| Exports an entire table as a CSV file. |
| Retrieves the details of a customer by ID in Stripe |
| Retrieves the details of an invoice by ID in Stripe |
| Retrieves the details of the invoice item in Stripe |
| Retrieves the details of an invoice item in Stripe |
| Cancels a subscription in Stripe |
| Retrieves the schema (column definitions) of a PostgreSQL table. |
| Inserts a new record into a PostgreSQL table. |
| Inserts a new row into a PostgreSQL table. |
| Lists all databases in a PostgreSQL instance. |
| Lists all tables within a specified schema in PostgreSQL. |
| Selects rows from a PostgreSQL table based on specified criteria. |
| Updates existing rows in a PostgreSQL table. |
Triggers
The following actions are available to create custom automations on the Unifyapps platform:
Trigger | Description |
| Triggers when a record/batch of records is inserted/updated in a table in PostgreSQL |
| Triggers when new rows/batch of rows is created in a table in PostgreSQL |