Online Documentation for SQL Manager for PostgreSQL
Working with data
If necessary, you can group the data in grid by any of the columns. This operation is performed by dragging the column header to the gray "Group by" box area at the top. When grouping by a column is applied to the grid, all the rows are displayed as subnodes to the grouping row value. To reverse grouping, just drag the column header back.
For Materialized views the following operations are available on the Navigation bar or Toolbar:
refreshes data of materialized view
clears data of materialized view (REFRESH with NO DATA)