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
Is your feature request related to a problem? Please describe.
Currently
format.schemaemitsname,type,nullableand 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_pkfield for each column that indicates if this column is (part of) primary key for tableDescribe alternatives you've considered
The only possible alternative is using all the fields in
payload.beforein WHERE clause of DELETE/UPDATE with format.column = 2 (compact mode disabled) which is huge overkill for tables with many columnsAdditional context