Online Documentation for SQL Manager for PostgreSQL

Object Editors


All

CheckBox Convert created objects' names to lower case

Enable this option if you need to convert the names of all newly created objects to the lower case automatically.

 

CheckBox Show OWNER on DDL tab

With this option enabled OWNER statement is generated for the objects on the DDL tab, otherwise it's removed from the object definition.

 

CheckBox Always open the first tab

If this option is checked, the first tab is activated by default on opening an object in its editor.

 

Table editor

CheckBox Show Object Explorer

Enables/disables the Object Explorer panel within the Navigation bar of Table Editor.

 

CheckBox Do not retrieve record count for a table

Check this option to disable retrieving record count for tables (with this feature enabled, opening large tables may take much time).

 

CheckBox Serial columns as integer

With this option enabled, 'serial' type columns will be displayed as 'integer'.

Environment Options - Tools - Object Editors

 

Function editor

CheckBox Dollar-quoted function body on server 8.0 and higher

This option allows dollar-quoted function body definition.

 

CheckBox Split function options into several lines in DDL

Use this option to define whether to split function options into several lines in DDL or to display all options in one line.

 

CheckBox Execute with definer's privileges as default

This option specifies that the function is to be executed with the privileges of the user that created it. Otherwise, the function is to be executed with the privileges of the user that calls it. If this option is enabled then the CheckBox Execute with definer's privileges option in the Function Editor when creating a new function will be checked automatically.

 

Object list style

These options allow you to define the style of the combo-boxes used to select database objects (e.g. Table or view in Trigger Editor). Objects can be represented as a tree, a list sorted by namespace or a list sorted by name. Use the CheckBox Ignore case option to enable/disable case sensitive sorting.