Usage

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.

meta commands

\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

sql shortcuts

\from ... select * from ...
\cfrom ... select count(*) from ...