How to output from isql the result of a sql select query to a file in Virtuoso?
What?
Output iSQL result of a SQL SELECT Query.
Why?
Manage the results of a SQL SELECT Query by using by saving into a file for convenience.
How?
In order to save the output in a file from a SQL SELECT query executed from Virtuoso iSQL, one should use the following syntax:
isql <port> user pass exec="SELECT ..." > {file-name.{ext}}
Related