Online Documentation for SQL Manager for PostgreSQL

Options


The Options section of the Database Registration Info dialog allows you to set various options for the database.

 

Database Registration Info - Setting common database options

 

 

Customize common database options according to your needs. The detailed description is given below.

 

CheckBox Login prompt before connection

Enables SQL Manager for PostgreSQL to prompt for user name and password each time you connect to the database.

 

CheckBox Show system objects

This option determines whether PostgreSQL system objects are displayed in the DB Explorer tree.

 

CheckBox Autoconnect at startup

Check this option to specify that SQL Manager for PostgreSQL automatically establishes connection to the registered database at application startup.

 

CheckBox Refresh objects on connection

This option allows you to enable/disable refreshing objects on connection to the database. It is highly recommended to uncheck this option if your database contains many objects or if connection to the database is slow.

 

CheckBox Schema-organized database tree

If this option is disabled, the object tree is built without grouping into schemas.

 

CheckBox Ping server every ... seconds

Defines minimal time interval for PostgreSQL server to be pinged. You may find this option useful in some cases.