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:
|\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