Queryregion

Syntax : queryregion "<POSTGRESQL QUERY>" <ENTER>

Description : Executes the given postgresql query on the available region and gets the response in tabular form.

---

JINT example

var table = di.queryregion("select * from accountupdate"); di.display("Got the data..."+table.Rows.Count); for(var x=0;x<table.Rows.Count;x++) { var account_id = table.Rows[x]['Id']; var account_name = table.Rows[x]['Name'];

       ...maybe import into another system...etc

}