jydbconsole is started by run.sh (in unices) or run.bat (in windows). The script starts swing user interface. Alternative terminal interface is run by jython TextConsole.py.
Probably first command is to connect to the database. This is done by \connect command. In swing, commands are executed by Ctrl-Enter, in terminal by Enter.
\q | quits jydbconsole |
\dt | lists tables in a database |
\dt table | description of table |
\dv | lists views in a database |
\dv view | description of view |
\dp | lists procedures in a database |
\dp procedure | description of procedure |
\ds | lists sequences in a database |
\ds sequence | description of sequence |
\from ... | select * from ... |
\cfrom ... | select count(*) from ... |