Sortig Records

PostgreSQL Server stores records in the order they were added to the table. Sorting in Navicat is used to temporarily rearrange records, so that you can view or update them in a different sequence.

Click the column caption whose contents you want to sort by, right-click to select the Ascending or Descending mode from the popup menu or choose from the toolbar.

Hint: Remember to remove all sorting before applying on another column.

Finding Records

The Find Dialog is provided for quick searching for the text in the editor window. Just simply click Edit -> Find from the menu or press Ctrl+F and enter a search string.

The search starts at the cursor's current position to the end of the file. There will not have differentiates when performing a uppercase or lowercase search.

To find for the next text, just simply select Edit -> Find Next or press F3.