Creates a new node within a network. The name of the new node must differ from all existing nodes in the network. Note that it is only possible to create an instance node on a server that has already been provisioned with the Edge Intelligence product.

Available in the network database and requires the star$network role.


Name Optional Type Description
node$ Mandatory Text The name of the node to be created.
description$ Optional Text A description of the node.
type$ Mandatory Char The type of node (A,E,I)
host$ Optional Text Server name or IP address for an instance node
address$ Optional Text Optional address information for an instance
location$ Optional Text Optional geographical location information
location$ Optional Numeric Optional latitude of the node
latitude$ Optional Numeric Optional longitude of the node


SELECT create_node('mynode','my node','A',null,null,null,null,null); -- creates an area node.

SELECT create_node('mynode','my node','E',null,null,null,null,null); -- creates an edge node.

SELECT create_node('mynode','my node','I','host',null,null,null,null); -- creates an instance node.


  • Use a null value to omit an optional value.
  • The star$nodes view indicates which nodes already exist.
Have more questions? Submit a request


Article is closed for comments.

Powered by Zendesk