Online Documentation for SQL Manager for PostgreSQL
By default, data returned by a query is displayed as a grid. It is indicated by the Grid View tab selected on the View mode panel at the bottom of the Results area of the window.
When in the Grid View mode, the columns correspond to the columns and the rows correspond to the records.
If more convenient, you can change the order of the columns by dragging their headers horizontally. Clicking the column caption sorts data by the values of this column in the ascending or the descending mode. The navigation pane at the top of the grid allows you to browse the data quickly, to insert, update and delete records, and to set a filter for the records using the Filter Builder dialog and other tools.
The Navigation bar of the parent window, toolbars and the context menu of the grid provide you with a number of data management functions: Export Data, Import Data, Export as SQL Script and more.
- Customizing columns
- Grouping and sorting data within the grid
- Filtering records
- Using the context menu
- Working in multi-level mode
- Browsing data in card view
- Column Summary
- Copying records
Hint: To increase the speed of opening tables and views with extremely large number of records, you can use options of the Limit options in table and view editors group available in the Grid | Data Options section of the Environment Options dialog.