Virtuoso Open-Source Edition

  • Topic
  • Discussion
  • VOS.VirtTipsAndTricksGuideISQLQueryResultOutput(Last) -- DAVWikiAdmin? , 2017-06-13 05:49:38 Edit WebDAV System Administrator 2017-06-13 05:49:38

    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