PostgreSQL Detect Renames Setting

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"

Didn't find what you were looking for?