Online Documentation for SQL Manager for PostgreSQL

Adding objects to query


An object can be placed to query from DB Explorer. Just drag-and-drop the required object from DB Explorer tree or from SQL Assistant to editor. Define statement for the object in the appeared window.

Note: You can drag-and-drop objects from DB Explorer to Query Designer too.

 

DB Explorer - Insert to Editor

 

Use the Statement list to define statement for the object: Name, SELECT, INSERT (parameters are used instead of values), UPDATE, DELETE, CREATE, DROP, Columns, List, Name and Type.

 

You can define alias for an object and prefix for variable in the respective fields.