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>
where:
<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
network=>
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
Comments
Article is closed for comments.