Browse and edit PostgreSQL data
Browse PostgreSQL schemas and tables, filter rows, inspect values and stage checked edits before committing.
Tablyne starts with the PostgreSQL hierarchy rather than a flat list of tables. You can move through databases, schemas and objects, then open a table in the data grid without losing the connection context.
Find the table
- Use the sidebar to open a database and schema.
- Select a table and wait for its first page of rows.
- Use the filter… control for a quick search, or add a structured condition when the filter needs a real
WHEREexpression. - Open Columns when you need to change the visible column set.
The PostgreSQL grid supports sorting, pagination, multi-selection and an inspector with database-aware formats. Foreign-key navigation can take you from the selected value to the referenced table. The ERD and schema views keep the relationship context beside the rows.
Stage the edit
Edit a cell in place, then leave the row in a staged state. The grid does not immediately send the change to PostgreSQL. The review surface lists the changed columns and the SQL that would run. A row can be discarded before the commit, so a mistaken edit does not require a compensating write.
The write uses the row identity and the version captured when the row was read. For a normal PostgreSQL table that check is xmin; a stale version causes the operation to affect no row and the whole batch is rejected.
Keyboard flow
- Ctrl+S saves pending changes.
- Ctrl+Z undoes the last grid change.
- Ctrl+Y redoes it.
- Shift+Enter opens the selected cell value.
- Ctrl+E opens data export.
The same flow applies when a table has a composite primary key. Tablyne keeps the key columns in the generated predicate instead of guessing from the displayed row order.