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/ navigate to connections page by clicking on the connections on the left side bar or by clicking https //app engini io/connections click on the "add connection" option located at the top bar choose postgres sql option from available applications enter the following details in the "add connection" 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 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 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) filter add conditions to filter the records you want to retrieve choose the field, condition, and value to limit the results to what you need sort by choose the field by which you want to sort the retrieved records you can also specify whether the sorting should be in ascending or descending order 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 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 filter add conditions to specify which records should be updated you can select a field, set a condition, and provide a value to filter the records 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 filter use this option to set conditions or filters to specify which records should be deleted this ensures you only delete the intended records 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 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 define the maximum number of rows to retrieve the default value is 100 filter add conditions to filter the records before retrieval you can choose a field, set a condition, and define a value to limit the results sort by choose the field to sort the retrieved records by you can select ascending or descending order 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 filter add conditions to specify which records should be updated you can choose a field, set a condition, and provide a value to filter the batch 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) describe object this action retrieves the metadata and structural definition of a specific database entity table enter the name of the table where the batch of records will be updated ensure the correct postgresql table is selected describe object get records this action explores the object's schema and retrieves its actual data rows to provide a complete view of the table's structure and content table enter the name of the table where the batch of records will be updated ensure the correct postgresql table is selected