Skip to content

Display real column types in data tables #17

@TeaCoder52

Description

@TeaCoder52

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.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions