Pull

Syntax

pull island destinationname "<whereclause>"

Please note:

If we wants to use query select statement with LIKE operator as case insenstive then we need to use ILIKE instead of LIKE operator as PostgreSQL understand ILIKE to make where condition as case in-sensitive, so for example, we need to give the payload as:

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