PostgreSQLHandler function

PostgreSQLHandler function is used to handle all the postgreSql services like inserting and fetching data.

Create Operation

This operation is used to create a table in the database.

Select SET command from the action dropdown and provide a variable name in Element key, edit parameter section and click on Form, select functions from the dropdown and select POSTGRESQLHANDLER function. Select operation as create, provide hostname, port, databasename, username, password and sqlquery.

Depending upon the query it will create a table in the database.

 

Update Operation

This operation is used to do some updation in the data.

Select SET command from the action dropdown and provide a variable name in Element key, edit parameter section and click on Form, select functions from the dropdown and select POSTGRESQLHANDLER function. Select operation as update, provide hostname, port, databasename, username, password and sqlquery.

Depending upon the query it will update the data.

 

Select Operation

Select operation is used to fetch some data from the database.

Select SET command from the action dropdown and provide a variable name in Element key, edit parameter section and click on Form, select functions from the dropdown and select POSTGRESQLHANDLER function. Select operation as select, provide hostname, port, databasename, username, password and sqlquery.

Depending upon the query it will fetch the data from the database and store it in a variable defined in Element Key.