Skip to main content
PostgreSQL works like the rest of FlexTable (connect, browse and edit, query). This page covers what is specific to Postgres.

​
Schemas

A Postgres database has multiple schemas (for example public). The sidebar groups tables by schema, so you can browse and switch between them.

​
Rich types

Postgres types render and edit correctly in the grid and cell viewer:
  • JSON / JSONB - pretty-printed and searchable in the cell detail panel.
  • Arrays, enums, and ranges display as their real values.
  • Case-insensitive text search (ILIKE) is used by default in the quick filter.

​
Structure

The Structure tab shows columns, indexes (including uniqueness), foreign keys, and triggers. Foreign keys are drawn as relationships in the ER diagram.

​
Query plans

Run Analyze on a SQL statement in the query editor to read the plan as a visual tree and find where time is spent.