Content


Overview

Click a table in the object tree and the content area opens Content, the results grid. The same table also has two other views, switched with Content | Structure | Info at the right of the tab bar:

Full-window view: the red box marks the Content / Structure / Info view switcher

Full-window view; the red box marks the view switcher (top right of the table)

ViewContents
ContentTable data, filterable, sortable, and editable
StructureTable structure: columns, indexes, foreign keys, constraints, table options
InfoBasic table information and the CREATE statement

All three views belong to the same tab; switching does not open a new page.

Toolbar

The toolbar at the right of the tab bar provides:

  • +: create a new tab for the current connection.
  • Refresh icon: reload the data of the current view (Cmd+R, win: Ctrl+R).
  • Close button: close the current tab.

Refresh data

If someone else changes the data, refresh to get the latest results. Refresh only reloads the current view and does not affect filters you have set.

DataGrid

The DataGrid is the grid shared by table data and query results: column headers and the filter row at the top, the data area in the middle, and the FILTERS / ROWS / CELL / OUTPUT panels and the Page bar at the bottom.

The DataGrid in full

The DataGrid in full: column headers, filter row, data area, bottom panels, and Page bar

▶ Tutorial: DataGrid

Column menu → row menu → paging and status bar

Column menu

Right-click a column header to open the column menu:

CommandAction
Hide ColumnHide the current column
Show All ColumnShow all columns again
Sort / Clear sortSort by this column or clear the sort
Copy NameCopy the column name
Copy All NameCopy all column names
Columns ▸Open the column picker and check the columns to show
Toggle Show FilterShow / hide the filter row

Row menu

Right-click any row to open the row menu:

CommandAction
Edit / Set NULL / Set EmptyEdit the current cell or set it to NULL or empty
Quick FilterQuickly filter by the selected value
Add row / Duplicate row / Delete rowAdd, duplicate, or delete rows
Compare Row DataCompare data across rows
Find/Replace in DataFind and replace in the results (Cmd+F)
Export…Export the results
Copy as ▸Copy as text, JSON, SQL, and other formats
Go To ▸Jump to a given row or column

Copy as

Both the row and column menus have a Copy as submenu that copies the selection in different formats:

CommandWhat it copies
Copy Cell Value(s) (Default)The selected cells; multiple rows and columns are tab-separated
Copy Selected Row ValuesEntire row values, comma-separated
Copy Selected Column Name(s)Names of the selected columns, comma-separated
Copy All Column NamesAll column names
Copy as Sql InsertGenerates an INSERT statement
Copy as Sql Insert Skip autoGenSame, but skips auto-increment / generated columns
Copy as Sql UpdateGenerates UPDATE by primary key, excluding primary key columns
Copy as Sql DeleteGenerates DELETE by primary key
Copy as Plain TextA text table
Copy as JSONA JSON array
Copy as HTML TableAn HTML table
Copy as XmlXML
Copy as CSV whith HeaderCSV with a header row
  • Generated SQL is built from the current table’s columns and primary key and can be pasted into the editor and run directly.
  • Copy as Sql Update / Delete require a primary key; tables without one cannot produce conditional statements.

Column indicators

A thin color bar to the left of each column name indicates the constraints on that column; a column with several constraints shows several segments side by side. Colors are controlled by theme variables:

ConstraintColorTheme variable
Primary keyOrange-red #f84c08--column-cons-pk
CheckYellow #f8cc08--column-cons-check
UniqueGreen #6ff106--column-cons-unique
Foreign keyCyan #08f8f0--column-cons-foreignKey
IndexBlue #0880f8--column-cons-index

Constraint color bars left of column names

An orange-red bar (primary key) left of CustomerId and a blue bar (index) left of SupportRepId

  • Hover a column header to see its type, nullability, foreign keys, and comment in the tooltip.
  • To hide these color bars, turn off Enable columnCons Color (Display column constraints color) in the settings.

Value colors

Values are colored by type for quick recognition:

TypeColor
numberCyan #00adcc
decimalOrange #de7a0e
date / timeBlue #258ef1
blob / clobGray-purple #9eadcf
geometryPurple #9563f7
NULLGray text

Values colored by type

Types shown in one table: decimal in orange, timestamp in blue, bytea with MIME type and size, NULL in gray

Row state has its own colors: new rows in green, rows pending deletion in red, modified rows in blue, and search hits highlighted in yellow.

Bottom panels

Below the data area is a row of panels, switched by tab, each showing the current result set from another angle:

TabPurposeSee also
FILTERSShow filter conditions as a table; add, remove, sort, and locate themFilter
ROWSExpand fields row by row, good for long text and imagesRows
CELLFull contents of the current cell and an editorBasic Editing, Binary & Image, JSON Editing
OUTPUTStatements that ran, timings, and errors—
Raw SQLBelow the FILTERS panel, showing the final SQLFilter

Drag to resize the panel; the arrow at the top right expands it to the full window for large blocks of text or images.

Paging & row count

Opening a table fetches only the first rows instead of loading the whole table into memory; scrolling to the bottom loads the next page. The left and right arrows in the bottom toolbar page through results (Cmd+Shift+[ / Cmd+Shift+], win: Ctrl+Shift+[ / Ctrl+Shift+]).

The status bar shows the current result’s row count and two timings, for example Rows 59 in table 22ms (31ms): the value before the parentheses is Query Time and the value inside is duration Time.

Column width & overflow

  • Drag a column border to resize it.
  • Content wider than the column is truncated; hover to see it in full.
  • The icon at the right of the column header opens the column menu to control which columns are shown.

Status bar

The status bar at the very bottom of the window gives the current context:

FieldMeaning
Rows N in tableResult row count and two timings: Query Time before the parentheses, duration Time inside
LengthLength of the selection
SelectedNumber of selected cells
Row x,Col yCursor row and column
Editable / Read OnlyWhether the current result is editable

Shortcuts

ActionShortcut
Search in resultsCmd+F, win: Ctrl+F
Add rowCmd+N, win: Ctrl+N
Duplicate rowCmd+D, win: Ctrl+D
Delete rowCmd+Backspace, win: Delete
Refresh dataCmd+R, win: Ctrl+R

Find/Replace in Data

Find content in the result set without changing filters; it only locates and highlights matches.

Open it from the Find/Replace in Data button in the toolbar or the same item in the data area’s context menu; shortcut Cmd+F (win: Ctrl+F).

▶ Tutorial: Find in data

Open search → highlight matches → expand replace

Search in results

Searching for America highlights matches in green and shows 5/69 on the right

The search bar floats at the bottom of the grid and contains:

ElementAction
Input boxType a keyword and press Enter to search
AaCase-sensitivity toggle
5/69Current match number and total matches
⌃ / ⌄Jump to the previous / next match
×Close the search bar and clear highlighting
> on the leftExpand the replace input box

Search bar

The search bar with the replace input expanded

Search syntax

FormExampleMeaning
ContainsAmericaContains this text
% prefix%AmericaEnds with America
% suffixAmerica%Starts with America
Regex/^America$/Match as a regular expression

Replace values

Click the > at the left of the search box to expand Replace with, enter the replacement, then:

ButtonAction
ReplaceReplace only the current match
Replace AllReplace all matches

Replacing changes values in cells, which are still uncommitted; click Apply back in the grid to write them to the database, or Revert to discard them.