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