Skip to content

Additional schema info - column primary key indicator #285

@esmin

Description

@esmin

Is your feature request related to a problem? Please describe.
Currently format.schema emits name, type,nullable and type related fields for each column.
This is enough for recipient who don't know schema, to construct INSERT command, but in order to build UPDATE or DELETE commands info on primary key is needed

Describe the solution you'd like
Additional is_pk field for each column that indicates if this column is (part of) primary key for table

Describe alternatives you've considered
The only possible alternative is using all the fields in payload.before in WHERE clause of DELETE/UPDATE with format.column = 2 (compact mode disabled) which is huge overkill for tables with many columns

Additional context

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