Feature description
Add display of actual column types (e.g., INT, VARCHAR, DATE) directly in the data tables.
Use case / motivation
When working with databases, it’s often necessary to know the data type of columns to write queries correctly and avoid type errors.
Suggested implementation
- Display a small label or text next to the column name in the table (e.g., id INT, name VARCHAR(255)).
- On hover, show a tooltip with full information about the column type, constraints (NOT NULL, DEFAULT, PRIMARY KEY).
- Extend the API endpoint that returns table data to include column types.
- Provide a UI toggle “Show column types” so users can enable or disable this display.
Examples / references
pgAdmin displays column data types when viewing table structure.
Feature description
Add display of actual column types (e.g., INT, VARCHAR, DATE) directly in the data tables.
Use case / motivation
When working with databases, it’s often necessary to know the data type of columns to write queries correctly and avoid type errors.
Suggested implementation
Examples / references
pgAdmin displays column data types when viewing table structure.