Home

SQL Tabs Documentation

Running SQL

SQL Tabs can run single SQL statements as well as scripts. When you choose in menu "Run Query" the whole content of editor area is sent to Postgresql server as a single script. In case there were multiple statements the result area will display query result for each of them the similar way psql does that.

When you want to execute only part of script just select a needed area and press "Run Query". Another way of partial execution is to split script to blocks by lines started with three dashes like this:

SELECT 1;

--- block separator

SELECT 2;

--- one more block

SELECT 3;

If you do so and press "Execute Block" menu item then the statements of block where cursor is placed will be run.

Info about database objects

The summary info about database and its schemas is accesible after pressing menu item "Database -> Database Info". There are clickable objects so you can navigate between object without any typing.

In order to get information about particular database object you can write its name in the editor and place the cursor on it. Then pick an "Object Info" menu item under "Database" menu or press a corresponding shortcut.

In case there were no object under cursor the database summary will be displayed.

In order to list all objects of particular schema you can type the schema name with dot in the end and press "Object Info" shourtcut. Like myschema.