Creates a new port for injecting messages into a local table.
Available in a network database and requires the star$network role.
Parameters:
| Name | Optional | Type | Description |
| name$ | Mandatory | Text | The name of the port to be created. |
| description$ | Optional | Text | A description of the port. |
| tables$ | Mandatory | Char | The local table the port injects into |
| adaptor$ | Mandatory | Text | The adaptor to be used for message parsing |
| arguments$ | Mandatory | Text | The arguments for the adaptor configuration |
Examples:
SELECT create_port('myport','my port','mytable','json','temp','temperature','id',null,null); -- creates a port for mapping json messages to 'mytable'.
Tips:
- The star$ports view indicates which ports already exist.
Comments
Article is closed for comments.