Online Documentation for SQL Manager for PostgreSQL

Tools


CheckBox Show only connected databases in drop-down menu

If this option is checked, only connected databases are displayed in drop-down menus of such tools as Design Query, Execute Script, etc.

 

CheckBox Allow using parameters in query text

This feature allows you to specify different values within a query in a popup dialog just before the query execution.

You can set the character to specify a parameter within the query in the Parameter sign char field.

 

CheckBox Use transactions in Data tab of object editors, Query Data and Design Query*

If this option is enabled, a transaction is active until the 'Data' tab is closed or the 'Commit' button is pressed; all edited records are blocked until the transaction is committed. If this option is disabled, the transaction starts and is immediately committed (autocommit) on saving each record which is blocked only for a short period of time.

Environment Options - Tools

CheckBox Asynchronous query execution*

Check this option to allow executing queries in background mode (asynchronously).

 

CheckBox Use separate connection for each data view within a database*

Uncheck this option to use separate connection for each data view within a database. Note that this option is only available when the Use transactions in Data tab of object editors, Query Data and Design Query option is enabled.

 

CheckBox Convert line end to Linux style in string constants of executed SQL statements

Check this option to transform all the multi-line literals to Linux-like form, using one-byte line breaking term.

 

New tool form should be opened for

This option defines which database should be selected in the launched tool.

RadioButton Database currently selected in DB Explorer

Tool will be opened with the database focused in the DB Explorer selected.

 

RadioButton Database selected in currently focused form

Tool will be opened with the database which is selected in the current form.