Pull

Syntax

pull island destinationname "<whereclause>"

Please note:

If we use LIKE operator in where clause then we are replacing to ILIKE as PostgreSQL understand ILIKE to make where condition as case in-sensitive, so for example, if we give the payload as:

"{\"Query\": \"select * from customers where \\\"CompanyName\\\" like '%Ana%'\"}"

then internally (in backend side) it will replaced as below and then process:

"{\"Query\": \"select * from customers where \\\"CompanyName\\\" ilike '%Ana%'\"}"

In case if we already given ilike then it will not replaced.