Online Documentation for SQL Query for PostgreSQL

Database management tools


SQL Query 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 Query below.

 

Registering Hosts

  • select the Database | Register Host... main menu item or use the corresponding btnRegisterHost toolbar button;
  • set all the necessary options using Register Host Wizard which guides you through the whole process of Host registration.

 

Registering Databases

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

  • select the Database | Register Database... main menu item or use the corresponding btnRegisterDB toolbar button;
  • check the Register a single database option and set all the necessary options using Register Database Wizard which guides you through the whole process of Database registration.

 

In order to register several databases at one host:

  • select the Database | Register Database... main menu item or use the corresponding btnRegisterDB toolbar button;
  • deselect the Register a single database option and set all the necessary options using Register Database Wizard which guides you through the whole process of Database registration.

 

Unregistering Databases

In order to unregister a single database in SQL Query for PostgreSQL:

  • select the database to unregister in the DB Explorer tree;
  • select the Database | Unregister Database main menu item or use the corresponding btnUnregisterDB toolbar button;
  • confirm unregistering in the corresponding dialog window.

 

In order to unregister a host and all databases at the host:

  • select the host to unregister in the DB Explorer tree;
  • select the Database | Unregister Host main menu item or use the corresponding btnUnregisterHost toolbar button;
  • confirm unregistering in the corresponding dialog window.

 

Connecting to Databases

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

  • select the database to connect to in the DB Explorer tree;
  • double-click its alias

or

  • select the Database | Connect to Database main menu item or use the corresponding btnConnectToDB toolbar button

or

  • right-click its alias and select the Connect to Database context menu item.

 

Disconnecting from Databases

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

  • select the alias of the database to disconnect from or any of its objects in the DB Explorer tree;
  • select the Database | Disconnect from Database main menu item or use the corresponding btnDisconnectFromDB toolbar button

or

  • right-click its alias or any of its objects and select the Disconnect from Database context menu item.