JSON, JSONB and other types
Postgres has a rich type system, and ide99 renders these in the grid in a useful way — not as raw text.
JSON and JSONB
A compact preview shows in the cell: {"foo": "bar", ...} (with ellipsis if longer than 60 characters).
Double-click → opens the full JSONB editor with three modes: text, tree, table.
If the result has exactly one jsonb column — a JSON tab appears above the grid with the full pretty-printed output.
Arrays
text[], int[] etc. show as {a, b, c} (Postgres notation).
Double-click — opens an array editor: list of elements, add/remove/reorder buttons.
Multidimensional arrays (int[][]) are read-only in the grid — edit them via SQL.
Hstore
An hstore cell shows as key1=>"val1", key2=>"val2". Double-click — modal with key-value editor.
Hstore is considered legacy. For new tables prefer jsonb — it has indexes (gin), typing, and more operators.
UUID
Just text — 550e8400-e29b-41d4-a716-446655440000. No special UI.
You can copy with one click via right-click → Copy as text.
Bytea
Binary data. The preview shows the first 16 bytes in hex: \x89504e470d0a1a0a0000000d.
If ide99 detects PNG/JPEG/GIF (by leading bytes) — right-click → Show as image opens the image in a viewer.
Geometry / Geography (PostGIS)
See the PostGIS page. The grid shows a WKT preview: POINT(37.6 55.7). If the PostGIS Power Pack is active — there's a Map View tab to visualize on a real map.
Vector (pgvector)
Preview of the first 4 components: [0.123, -0.456, 0.789, 0.012, ...].
Double-click — modal with the full vector (numbers stacked), one-click copy. Full vector workflow — in pgvector.
Range (int4range, tsrange)
Shows as [1, 100) or [2026-01-01, 2026-12-31). Not editable in the grid — use SQL.
Enum
Dropdown when editing, plain text in the view.
Composite (custom row types)
Preview with field names: (name="Alice", age=30). Read-only in the grid, edit via SQL.
Network (inet, cidr, macaddr)
Plain text, no special handling.
Money
Formatted by Postgres locale: $1,234.56 or 1 234,56 ₽.
Range and unrepresentable
If a value is unusual (legacy types, custom types without an output operator), ide99 shows <unrepresentable> and a hint bar at the bottom:
3 cells in this result use a type ide99 cannot display.
Use the SQL editor to inspect or modify them.
NULL
Italic gray: NULL. Different from an empty string "" (which shows as a blank cell with highlight on selection).
Next