Online Documentation for SQL Manager for PostgreSQL

Database Management


SQL Manager for PostgreSQL provides a number of tools you may need to manage your PostgreSQL databases.

Find the list of common database management operations for working in SQL Manager below.

 

Unregistering host

In order to unregister a host in SQL Manager for PostgreSQL:

  • select the host to unregister in the DB Explorer tree, then select the Database | Unregister Host main menu item or use the corresponding btnUnregisterHost Unregister Host toolbar button;
  • right-click the host alias and select the Unregister Host context menu item in the DB Explorer tree;
  • confirm unregistering in the corresponding dialog window.

 

Creating database

In order to create a database in SQL Manager for PostgreSQL:

  • select the Database | Create Database main menu item or use the corresponding btnCreateDB Create Database toolbar button;
  • set all the necessary options using Create Database wizard which guides you through the entire process of creating a new database.

 

Dropping database

In order to drop a database in SQL Manager for PostgreSQL:

  • select the database to drop in the DB Explorer tree;
  • select the Database | Drop Database main menu item;
  • confirm dropping in the corresponding dialog window.

 

Registering database

In order to register a single database in SQL Manager for PostgreSQL:

  • select the Database | Register Database... main menu item or use the corresponding btnRegisterDB Register Database toolbar button;
  • right-click any database alias and select the Register Database... context menu item in the DB Explorer tree;
  • set all the necessary options using Register Database wizard which guides you through the entire process of database registration.

 

Unregistering database

In order to unregister a database in SQL Manager for PostgreSQL:

  • select the database to unregister in the DB Explorer tree, then select the Database | Unregister Database main menu item or use the corresponding btnUnregisterDB Unregister Database toolbar button;
  • right-click the database alias and select the Unregister Database context menu item in the DB Explorer tree;
  • confirm unregistering in the corresponding dialog window.

 

Connecting to database

In order to connect to a database in SQL Manager for PostgreSQL:

  • select the database to connect to in the DB Explorer tree, then select the Database | Connect to Database main menu item or use the corresponding btnConnectToDB Connect to Database toolbar button;
  • right-click the database alias and select the Connect to Database context menu item in the DB Explorer tree.

 

Disconnecting from database

In order to disconnect from a database in SQL Manager for PostgreSQL:

  • select the database to disconnect from in the DB Explorer tree, then select the Database | Disconnect from Database main menu item or use the corresponding btnDisconnectFromDB Disconnect from Database toolbar button;
  • right-click the database alias and select the Disconnect from Database context menu item in the DB Explorer tree.

 

Viewing and editing database registration info

In order to view/edit database registration info in SQL Manager for PostgreSQL:

  • select the database or any of its objects in the DB Explorer tree, then select the Database | Database Registration Info... main menu item;
  • right-click the database alias or any of its objects and select the Database Registration Info... context menu item in the DB Explorer tree.

 

Viewing and editing database properties

In order to view/edit database properties in SQL Manager for PostgreSQL:

  • select the database in the DB Explorer tree;
  • right-click the database alias and select the Database Properties... context menu item or use the corresponding btnDBProperties Properties toolbar button.