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