Generic Postgres Executor

The Generic Postgres Executor allows you to connect to a PostgreSQL relational database. Pass an object with the parameters you require from the following table:

Code example

…
{
  "_orchcomp": "pg_executor", 
  "_name": "Connects to the PostgreSQL relational database", 
  "_sequenceno": 1, 
  "_actualparams": {
    "stmt": "<your-SQL-statement>", 
    "optype": "SELECT",
    "uname": "johnDoe", 
    "pwd": "secret",
  }
}, 
…

Generic Postgres Executor schema

Parameter	Type	Description	Required
_orchcomp	String	Enter “pg_executor”.	Required
_name	String	Enter a descriptive name for what the component does in the orchestrator.	Optional
_sequenceno	Number	Enter a number that defines the task’s order in the sequence of tasks to execute.	Required
_actualparams	Object	Pass an object that contains formal parameters or alternative parameters you want to add as key-value pairs, such as “userType”: “<your-user-type>”.	Optional
_actualparams.stmt	String	Takes a SQL statement as a string.	Optional
_actualparams.optype	String	Takes the operation type, such as INSERT, UPDATE, DELETE, or SELECT, as a string.	Optional
_actualparams.uname	String	Takes the database username as a string.	Optional
_actualparams.pwd	String	Takes the database password as a string.	Optional