josql is a utility that can be used to manage and query data through a SQL command interface.

The utility is used via the following command on a catalog server:

josql <network> <user>


<network> is the name of the network to connect to

<user> is the name of the user to connect as

Once connected you will get a prompt of


Where network is the name of the network.

The following commands are available in the command interface:

Command Description
\d  List tables and views in the public schema
\d <schema> List tables and views in the schema <schema>
\d <object> Describe a database object
\q Quit from the command session
\timing  Toggle timing of commands

See here for help with SQL Query Syntax



Have more questions? Submit a request


Article is closed for comments.

Powered by Zendesk