Can I run a query in Command line?

From Navicat Wiki

Jump to: navigation, search

Apply OS : Windows

Apply DB : MySQL, PGSQL, Oracle

Version : All


Yes, you can run a saved query from the command line. Please follow the steps :

  1. Create and save the query.
  2. Start Navicat from command line - Navicat /query ConnectionName DatabaseName QueryName


Note :

ConnectionName → name of the connection

DatabaseName → name of the database

QueryName → name of the saved query


You can create a batch job and set task schedule for the query. Refer to our user manual on how to create batch job and schedule in the chapter Schedule.

Retrieved from "http://wiki.navicat.com/wiki/index.php/Can_I_run_a_query_in_Command_line%3F"
Personal tools