Through a SSH session to a remote Linux server, I receive some text result and save it into a local variable as following.
Dim SSH_result as string
// SSH processing
// .............................
SSH_result = BufferString
At this time, I use a Xojo Shell to run ‘psql’ command for loading the text data into PostgreSQL database.
If my current data (BufferString) is created with a file, I could use below code by using a shell which passes the file data through STDIN.
Created file: remoteLinux_ssh_get_result
cat remoteLinux_ssh_get_result | psql -f event.sql
However, I want to use BufferString directly without creating a file. As there are so many sub-jobs doing this stuff at the same time, so I wanted to remove the logic which creates files locally in Windows.
Can you advise me if there is any way to pass BufferString into Shell command? Means that way to use BufferString data in Shell object.
Thanks in advance.