Online Documentation for SQL Manager for PostgreSQL
The Connection section of the Database Registration Info dialog allows you to view and/or edit the connection properties in the corresponding boxes.
Stores the name of the Host where the database resides.
Enter PostgreSQL port to connect through.
If necessary, edit the User name used to access the database.
If necessary, edit the Password used to access the database.
Stores the name of the database.
Stores the database alias which is displayed in the DB Explorer tree 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.
Stores the character set used to display data in the grid.
Set the alias for the current host to be displayed in the DB Explorer.
Once you have specified the connection properties, you can check whether it is possible to establish connection to the database: click the Test Connect button for this purpose. If connection is successful, you will get the 'Connected!' message; otherwise an error message will be returned.
The Copy Alias from... menu allows you to select the alias of a previously registered database and use it for the newly created/configured database.