Hello,
when using Postgres 10 or higher, it seems that pgoutput can be used as an output plugin for logical replication.
Does this allow to detect column renames ? Or is there a ticket for adding support if the feature does not exist (if it is feasible to implement) ?
What I was hoping to find is the ordinal position of columns and use that to infer column renames. As new columns always get a higher ordinal position and renamed columns keep their position. Hence, a column rename could be detected if different column names are received for the same ordinal position, by tracking the column name per ordinal position at the consumer. (Please let me know if any of that is incorrect)
cheers