Postgres SQL

learn how to seamlessly connect postgresql to engini, enabling efficient database integration for your workflows with the postgresql connector, you can manage data, run queries, and automate database interactions directly in engini enhance productivity by integrating postgresql's powerful capabilities into your business processes getting started with postgres sql prerequisites a postgresql account this includes the username and password to access the database connecting engini to postgres sql enter your engini account at https //app engini io https //app engini io/ navigate to connections page by clicking on the connections on the left side bar or by clicking here https //app engini io/connections click on the "new integration" option located at the top bar choose postgres sql option from available applications enter the following details in the "new integration" form connection name choose a name for easy reference to this postgresql connection server address the ip address or domain where the postgresql server is hosted database name the name of the specific postgresql database you want to connect to schema the schema within the database, usually set to public if no other schema is specified username the postgresql username with sufficient access rights password the corresponding password for the postgresql username communication channel ensure the communication channel (cloud or opa) is accessible for remote connection, depending on your preferred method save settings click on the save button located at the bottom of the form actions specific tasks you want to perform in your postgresql database through engini these actions can automate data management, such as inserting records, running queries, or interacting with specific tables and databases in postgresql create record this activity allows you to create a new record in a specified postgresql table table choose the table where the new record will be inserted make sure to select the correct table from your postgresql database add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields get records this activity retrieves records from a specified postgresql table or view you can set limits, sorting, and filters to refine the results table/view specify the name of the table or view from which you want to retrieve records ensure the correct postgresql table or view is selected top define the maximum number of rows to retrieve the default is 100 if no value is provided offset specify the number of rows to skip before starting the retrieval this is useful for pagination the default is 0 (no rows skipped) add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add sort click add sort to organize the data list by a selected field in ascending or descending order to learn more about sorting data, click here https //help engini ai/workflow editor#add sorts update record this activity allows you to update an existing record in a specified postgresql table table specify the name of the table where the record you want to update is located ensure the correct postgresql table is selected add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields update records this activity allows you to update multiple records in a specified postgresql table based on a filter you can specify the table, and add filtering conditions table enter the name of the table where the records you want to update are located ensure the correct postgresql table is selected add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields delete records this activity allows you to delete records from a specified postgresql table based on a defined filter table specify the table from which records will be deleted make sure to select the correct table from your postgresql database add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters create batch of records this activity allows you to insert a batch of records into a specified postgresql table data list specifies the list of records you want to insert the batch can handle up to 1000 items table the name of the table where the records will be inserted ensure the correct table from your postgresql database is selected add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields get records batch this activity retrieves a batch of records from a specified postgresql table you can define the batch size, set sorting and filtering options data list specifies the list of records to retrieve in a batch the maximum batch size is 1000 items table enter the name of the table from which you want to retrieve the batch of records ensure the correct postgresql table is selected top n define the maximum number of rows to retrieve the default value is 100 add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add sort click add sort to organize the data list by a selected field in ascending or descending order to learn more about sorting data, click here https //help engini ai/workflow editor#add sorts update batch of records this activity allows you to update a batch of records in a specified postgresql table you can provide the list of data to update, and set filtering conditions data list specifies the list of records to be updated the maximum batch size is 1000 items table enter the name of the table where the batch of records will be updated ensure the correct postgresql table is selected add filter click add filter to define conditions that narrow down the data list and return only the relevant items to learn more about using filters, click here https //help engini ai/workflow editor#add filters add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields execute customized sql this activity allows you to run a custom sql query directly on a postgresql database you can write any sql command, such as select, insert, update, or delete, and execute it against the database sql enter the custom sql query you want to execute ensure the query is correctly formatted for postgresql and targets the correct database objects (e g , tables, views) execute procedure this activity allows you to execute a stored procedure in a postgresql database a stored procedure is a set of sql statements that can perform a specific task, such as data manipulation or complex operations, in one call procedure name enter the name of the stored procedure you want to execute ensure that the procedure exists in the postgresql database and that it has the required parameters (if any) add field click add field to add and populate additional fields for the selected activity to learn more about managing activity data, click here https //help engini ai/workflow editor#add fields