Online Documentation for SQL Manager for PostgreSQL
Setting specific options
This step of the wizard allows you to set database alias, database options, logs and SSL parameters.
Type in or use the drop-down list to select the database to be registered.
Enter the alias to be used to display the database in DB Explorer and SQL Manager tools. By default, a database alias generated by the application has the following format: <database_name> on <host_name>[:<port>]
This option allows you to use multibyte encoding method in the database. Use the drop-down list to select the required encoding value, or leave this option to apply the default server encoding.
Specify the character set to be used to display data in the grid.
Login prompt before connection
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.
Autoconnect at startup
With this option set, connection to the registered database is established automatically at application startup.
Show system objects
If this option is checked, PostgreSQL system objects will be displayed in DB Explorer.
Ping server every ... seconds
Defines minimal time interval for PostgreSQL server to be pinged. You may find this option useful in some cases.
Create new tab for this database
Select the preferable SSL mode: Disabled, Allow, Prefer, Require, Verify CA, Verify Full. Allow, Prefer, Required, or Disabled.
Select the path to the client root.crt file.
Select the path to the client certificate.
Select the path to the client private key.
Select the file for Certificate Revocation List.
Enable log of metadata changes
Check this option if you wish to log metadata changes of your database in a file.
This field is enabled if the Enable log of metadata changes option is selected. Type in or use the Save as button to specify the path to the *.sql file to store the metadata logs.
Enable log of Query Data queries
Check this option if you wish to log your Query Data queries in a file.
This field is enabled if the Enable log of Query Data queries option is selected. Type in or use the Save as button to specify the path to the *.sql file to store the logs of SQL queries.
Enable this option to save logs in Unicode. If the option is disabled, ANSI will be used.
Click the Finish button when done to start working with the newly registered database in SQL Manager for PostgreSQL.