Skip to content

Scaffolding: introspect CHECK constraints and enum types #3

Description

@WailedParsley36

PostgresSchemaReader reconstructs tables, columns, primary keys, unique constraints, and foreign keys, but CHECK constraints and database enum types are not yet read. Add:

  • CHECK constraints via information_schema.check_constraints (skipping the synthesized NOT NULL checks).
  • Enum types via pg_type/pg_enum, mapped to [Table]-backed enums / InstantiatedValues.

Cover with the existing live-DB round-trip test (PostgresSchemaReaderTests).

Metadata

Metadata

Assignees

No one assigned

    Labels

    cliCLI tool (Socigy.OpenSource.DB.Tool)enhancementNew feature or requestscaffoldingDB to code scaffolding / introspection

    Type

    No type

    Fields

    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions