PostgreSQL Ignore Newlines In Text Objects Setting

Description

Ignore newlines within text objects when comparing databases.

Type

String

Valid values

  • "all"
  • "off"

Default

"off"

Usage

Flyway Desktop

This can't currently be set from Flyway Desktop, although it will be honoured.

Command-line

./flyway diff -redgateCompare.postgresql.options.ignores.ignoreNewlinesInTextObjects=all

TOML Configuration File

[redgateCompare.postgresql.options.ignores]
ignoreNewlinesInTextObjects = "all"

This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved


Didn't find what you were looking for?