EMS logo

Products Navigation

SQL Query for PostgreSQL

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Query for PostgreSQL

On-line Documentation

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

 

In order to register a host in SQL Query for PostgreSQL:

  • 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.

 

 


See also:

Database Explorer

Query management tools

Data management tools