PostgreSQL Detect Renames Setting
Published 12 March 2025
Description
Attempt to detect renamed database objects, then deploy renames in the resulting script rather than dropping and creating those objects.
Currently tables and columns are supported. In the future this option may support more object types and matching similar rather than identical objects.
Type
String
Valid values
"identical-only"
"off"
Default
"identical-only"
Usage
This setting can't be configured other than in a TOML configuration file.
Flyway Desktop
This can't currently be set from Flyway Desktop, although it will be honoured.
TOML Configuration File
[redgateCompare.postgresql.options.behavior]
detectRenames = "identical-only"