I would like to call and sql file with a query using input parameter. eg: providing where col1 = $param1 and col2 = $param2
it would also work for me if psql could be called with a query flag, (and provide query there) then i could handle it from bash.
Is there a possibility for any solution of the above two?
update: from bash it works already using sqlline.
from bash i can solve with sqlline, but is there a more sophisticated way? what is the best practice for such cases?