Online Documentation for SQL Manager for PostgreSQL

Create Query


Create Query in SQL Editor

  1. Choose Tools | btnNewSQLEditor New SQL Editor in the main program menu and write the query text in SQL Editor.
  2. Press the btnNewSQLEditor New SQL Editor button on the standard toolbar of the program and write the query text in SQL Editor.
  3. Use the shortcut <Shift+F12> and write the query text in SQL Editor.

 

Create Query in Query Builder

You can create a query in one of the following ways:

  1. Choose Tools | btnNewQueryBuilder New Query Builder in the main program menu and create a query in the Visual Query Builder.
  2. Press the btnNewQueryBuilder New Query Builder button on the standard toolbar and build a query on the diagram or in the editor area of the Visual Query Builder.
  3. Open btnShowSQLEditor SQL Editor or btnShowQueryBuilder Query Builder, drag any object from DB Explorer to SQL Editor or Visual Query Builder, select the type of the created query in the opened window.

 

 

Create simple query in Query Builder

  1. Open Visual Query Builder.
  2. Drag object from the DB Explorer tree or Objects group to the diagram area.
  3. Include the field in the query. Check the corresponding box located to the left from the field name in the list, or just double-click it. To include all fields of the table/view, check the box located to the left of the table/view caption. If you do not check any fields, the SQL statement is generated as SELECT * FROM <table/view_name>, i.e. all the fields are included in the query.
  4. Associate two objects by their fields. This operation is performed by dragging a field from one object list to another to set a link between these objects by the selected fields. It is indicated by a bidirectional arrow between the linked fields.
  5. Set the link properties using the linking arrow. The hint containing the association condition will popup after a short delay. To edit the link properties, double-click the linking arrow or right-click it and select the Property popup menu item. The Link properties dialog allows you to change the linking condition by choosing it from the drop-down list (=, >, <, >=, <=, <>).