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

Query management tools


When using SQL Query for PostgreSQL, you are provided with two basic tools you may need to manage your SQL queries: SQL Editor for editing  SQL query text directly and Visual Query Builder for building queries visually. Find the list of common SQL query management operations below.

 

Creating new queries

 

In order to create a new query in SQL Query for PostgreSQL:

  • select the Query | New Query main menu item or use the corresponding btnNewQuery toolbar button;
  • specify a name for the new query within the New Query dialog;
  • proceed to the Edit tab and use SQL Editor to edit the SQL query text

or

 

Editing queries

 

In order to open a query in SQL Query for PostgreSQL:

  • select the query in the DB Explorer tree;
  • right-click the query and select the Activate Query context menu item

or

 

In order to load a query from an *.sql file:

  • select the Query | Load... main menu item or use the corresponding btnLoadQuery toolbar button;
  • specify the query file within the Load SQL File dialog.

 

Executing queries

 

In order to execute a query in SQL Query for PostgreSQL:

  • create a new query or open an existing one;
  • select the Query | Execute main menu item or use the corresponding iconExecuteQuery toolbar button

or

  • use the F9 hot-key to execute the query.

 

Saving queries

 

In order to save a query in SQL Query for PostgreSQL:

  • create a new query or open an existing one;
  • select the Query | Save... or the Query | Save as... main menu item

or

  • use the Ctrl+S shortcut to save the query

or

  • use the Query | Save all queries main menu item if you need to save all the queries at a time.

 

 


See also:

Database Explorer

Database management tools

Data management tools