Guide · Every panel
Data grid
A table tab shows its rows in the grid. Views, materialized views and partitions open in it too: partitions can be edited, views can't, with "Views are read-only here. Change rows in the tables the view reads from." A query result uses the same grid, read-only.
Toolbar
Add row: stages a new row.Columns: show, hide and reorder columns.Reset layoutundoes it.Refresh, andAuto-refreshevery 5 to 60 seconds.Show in ER diagram.More actions:Find in loaded rows(Mod-Shift-f),Go to column(Mod-g),Copy as…,Export rows…,Open as SQL, andExplore relationshipswith a row selected.
Filter rows
Filter rows (Mod-f, Search table data) filters on the server. The Filter syntax popover lists:
| Write | Means |
|---|---|
= != > >= < <= |
Compare: total >= 100 |
~ !~ |
Contains, ignoring case: email ~ "acme" |
like ilike |
Pattern with % and _: name like "A%" |
in (…) |
Any of: status in ("active", "trialing") |
= null, != null |
Missing values, present values |
&& || ! ( ), or and or not |
Combine conditions |
Right-click a cell for Filter by this value or Exclude this value.
Sorting and columns
- The sort button on a header sorts ascending, then descending, then not at all. Shift-click adds another key. A plain click on the header selects the column.
- Column menu:
Pin left,Move left,Move right,Copy name,Fit to content,Hide,Format. Saved viewsstores the filter, sort and layout under a name (Name this view), on this computer only.
Paging
The grid loads Rows per table page, 100 by default, and fetches more as you scroll (Loading more…). The status bar shows the estimated total and Count, which is exact. A table with no primary key and too many rows to sort warns that rows load in the server's scan order, so a page can repeat or skip rows if that order changes.
Pending changes
Edits are staged, not written. The Pending changes bar ("Kept locally until you apply them") lists each with Revert this change. Discard drops them all, after asking. Review (Mod-s) opens Review staged changes.
Read: Edit data